relationships with more tables issue
Hi gentlemen, I'm new in this forum, thanks for your help.
My problem is:
i have one table: codetable--->code1,code2,description
and one table: itemused--->quantity,codeused
the relationship is codetable::code1=itemused::codeused so if i put in the field itemused::codeused one of a code stored in code1 i can catch the description of the item. But the item could have 2 codes (code2). How can I proceed in order to have the possibility to put in codeused one of the code2 and catch the same description?
Sorry for my "little" english, and marry chritmass!