Dlookup?

[lyn]

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.

 

[Bill Bradbeer]

Have you considered using a subform based on a query linking Au_Item table
and Authors within the Item form? With a bit of additional thought you
would probably be able to create a similar input form

Bill

 

[Lyn]

Thanks for answering. Yes, I did try that but still had
trouble when an item had more than 1 author. By its nature
in the case of more than 1 author for an item the query
will more than 1 record with the same itemID.