Dlookup?

  • Thread starter Thread starter Lyn
  • Start date Start date
L

Lyn

I posted this in *Getting startd but had no replies so I
will try again*.
I have a form used(in this instance)to view data in a
table, Items (PK ItemID). I want to include on the form a
control that will show the associated AutName(s)(not
included in Items since there can be >1) for each Item as
it is displayed. AutName comes from a table(Authors),
having 2 fields, AutID and AutName. Authors is linked to
the Items table by another table(Au_Item) having 2 fields,
AutID and ItemID (compound PK). I thought the control
would have to be a list box for the case when there is >1
author. Dlookup didn't seem to work; I thought because of
the interim table, Au_Item. Please, is there an obvious
way to do this? Also, would I be able to use the same form
to add data, or would the author control make it too
messy? Thanks in anticipation.
 
Lyn said:
I posted this in *Getting startd but had no replies so I
will try again*.
I have a form used(in this instance)to view data in a
table, Items (PK ItemID). I want to include on the form a
control that will show the associated AutName(s)(not
included in Items since there can be >1) for each Item as
it is displayed. AutName comes from a table(Authors),
having 2 fields, AutID and AutName. Authors is linked to
the Items table by another table(Au_Item) having 2 fields,
AutID and ItemID (compound PK). I thought the control
would have to be a list box for the case when there is >1
author. Dlookup didn't seem to work; I thought because of
the interim table, Au_Item. Please, is there an obvious
way to do this? Also, would I be able to use the same form
to add data, or would the author control make it too
messy? Thanks in anticipation.
Click to expand...

The obvious way is with a subform.
Create one that displays the items you want and includes the ItemID and drop
it on the main form.
You may have to go into the sub form properties and set the master child
relationship.
 
Thanks for answering. I will try the subform again. I had
tried it as well but still had trouble with >1 author per
item and the interim table.
 
Back
Top