Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Referencing the 1 side of a 1-Many Relationship (Access 2000)

    I have two tables: tblA and tblB. There is a 1-many relationship between them - i.e. one record in tblA can have many records in tblB. I also have a form, frmC, which uses tblB as its recordsource, with a filter. I know that I can reference a field from tblA in frmC by inserting a dlookup in the control source of the text box. I have done this and it works. I also know how to do a dlookup in the Form Open event to accomplish the same thing.

    My question is: Is there a way to directly reference the field from tblA, as in, for example,
    =tblA.[fieldname]?

    Thanks.
    Carol W.

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

    Re: Referencing the 1 side of a 1-Many Relationship (Access 2000)

    No. The only way to reference a field in a table is through a dlookup or by opening a recordset on the table. Of course, you could use a combobox on your form and bind it to tblA. Then you could automatically display a related value in the combobox.
    Charlotte

  3. #3
    3 Star Lounger
    Join Date
    Dec 2001
    Location
    Nevada, USA
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Referencing the 1 side of a 1-Many Relationship (Access 2000)

    Thanks for the reply.

    I've left it with the dlookup as the control source. It works fine although it does take an extra nanosecond to do the lookup and fill in the field!
    Carol W.

Posting Permissions

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