Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Nov 2001
    Posts
    192
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Create relationship by code (Access 2000)

    Is there any possibility to link 2 tables by a function?
    I have 2 tables, Customers and CallCustomers. I create the relationship between the field CallId(autonumber) in the table
    CallCustomers and the field Calls in the table Customers in one to many, by following the instructions of the wizard.
    Is there any way to build a code and create this relationship ?

  2. #2
    Lounger
    Join Date
    Apr 2001
    Location
    Khon Kaen, Thailand
    Posts
    43
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Create relationship by code (Access 2000)

    Check CreateRelation Method in Access Help.

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Create relationship by code (Access 2000)

    I'm not sure what you're asking. If you have already created the relationship between the tables using a wizard, why do you need code to do so? Did you want this for some other tables or are you talking about something besides a saved relationship between tables?
    Charlotte

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •