Look up field help!
Posted: 2013-02-15 20:44
Hi,
I have 3 tables: Part, Job and Defects.
Part table contains: Part Number, Description
Job table contains: Job Number, Part Number (Lookup from Part), and Description (Look up from Part based on Part Number, auto fill)
Defects table: Job Number (Lookup from Job), Part (Lookup from Job based on Job Number selected, auto fill), Description (Lookup from Job based on Job Number selected, auto fill)
I am able to view the part description in Job table, however, not in Defects table as it displays the key linked to part table. How can I modify the source code to display the actual description instead?
Thank you for your help in advance.
I have 3 tables: Part, Job and Defects.
Part table contains: Part Number, Description
Job table contains: Job Number, Part Number (Lookup from Part), and Description (Look up from Part based on Part Number, auto fill)
Defects table: Job Number (Lookup from Job), Part (Lookup from Job based on Job Number selected, auto fill), Description (Lookup from Job based on Job Number selected, auto fill)
I am able to view the part description in Job table, however, not in Defects table as it displays the key linked to part table. How can I modify the source code to display the actual description instead?
Thank you for your help in advance.