I have a column in access table that is a primary key with a couple other primary keys. The form I am talking about enters data into this table.
On another table it is the sole primary key. This table is for reference purposes and contains product ID's and product names which are not duplicated.
Can I have a text box on my form that just displays the name when I enter the product ID.
And, what relationships do I use to get the report to also reflect this name if it cannot pull from a data field on the original table?
Cheers,