Hello everyone,
I created 2 table that are linked to a link table so to get a many to many relationship.
I have a table for locations and a table for parts.
One location can have many parts and One part can belong to many locations, that is way the many to many relationship.
I'm struggling to find how to get values from the parts table to the Location table using the linked Primary Key in the foreign key linked field.
The values also have to be interactive, if I change the value in the part table it needs to update in the location table.
What can I put in the field of the location table to get a specific value from the parts table?
I tried setting the field to calculated field and put the Dlookup function but that didn't work. The lookup wizard seems to be the solution, but I can only create combobox or list box and I need to select the value manually. I just need a value to be put automatically by looking at the foreign key.
If I put the Dlookup function on the default value, those it update if a value is changed in the part table?
Anyone has any ideas on how I can go about this?