AnsweredAssumed Answered

relationships with more tables issue

Question asked by SlevinKelevra on Dec 26, 2010
Latest reply on Dec 27, 2010 by SlevinKelevra


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!