Need Help Linking Primary and Foreign Key

[mthrendyle]

Hi there, I am new to Access and haven't used query before, so explaining things in query to me is probably a bit useless.
Anyway, I want the ProductID's to show up in my Employee field, but I am having trouble doing so.

I was able to achieve this in my Materials table with Employee ID, which had autonumber as the data type.

Basically I want to be able to achieve the same thing from my materials table, but with my employees table, but with the product ID if that makes sense.

Thanks!

 

[Leandroarb]

Hi!
Is this possible only in queries, okay?
For this, the tables used in the query must have some field or fields in common, in which the information is related.
Is there a field in the tables?

 

[xenou]

To be honest, I can't think of any way you'd need a productID in an Employees table. Only Employee information should be in the Employees table (so you'd expect EmployeeIDs but never ProductIDs).

 

[Robby19]

Unless each Employee can only sell 1 Product I am not sure what is to be gained by this. Same with the Materials. Can each employee only handle 1 type of Material?