Need help setting up a complex row source

  • Thread starter Thread starter Dan Neely
  • Start date Start date
D

Dan Neely

I'm trying to create a form to let the user create new entries in a
link table. The problem is that one of the two FKs in it refers to a
table that doesn't have any one field that is suitable to use as an
identifier in the the forms combobox. Two values which are in the
table via foreign keys do provide a suitable userfriendly identifier
for the rows of the table. I can't do this directly when creating the
form since at most I can pull the two FKs, not the text they're
associated with. This also appears to be beyond what the form wizard
can be coaxed into doing, and I don't know how to manually set the
comboboxes rowsource up to get them. I have the tables described
below and in the form for Link1 I want the combobox selector for
Table1ID to have display "Lkup1Text - Lkup2Text"

Link1
Table1ID - this is the ID I'm having problems getting display text
for
Table2ID - The other ID in the link table, not a problem here.

Table1
Table1ID
Lkup1ID
Lkup2ID

Lkup1
Lkup1ID
Lkup1Text

Lkup2
Lkup2ID
Lkup2Text
 
I'm trying to create a form to let the user create new entries in a
link table. The problem is that one of the two FKs in it refers to a
table that doesn't have any one field that is suitable to use as an
identifier in the the forms combobox. Two values which are in the
table via foreign keys do provide a suitable userfriendly identifier
for the rows of the table
Click to expand...

Answering my own question. I didn't realize I could bring up the
query builder from the table design dialog. From there I was able to
get the fields I needed directly.
 
Back
Top