CODEWITHSUNDEEP
ms-accessrelational-databaserelationship
john777
john777

Reputation: 23

How to link multiple columns to one on Microsoft Access

I want to create a database where i simply need to type in the ID for something in multiple columns and this can bring me to when it was created and by who.

As you can see the Power on, TV, HDMI etc have an ID that will go up to 12, with model C having overlap between some ID's from A and B

enter image description here From this i can then determine that the ID 4 was created by Charlie

enter image description here The problem i have is that i have linked the two together like this, but it does not work, i cannot see who made the command. Have i done this correctly and is it possible to do

Upvotes: 0

Views: 784

Answers (1)

Gustav
Gustav

Reputation: 55806

Bring in five more instances of Relationship Table which will, by default, be suffixed with _1, _2, etc.

Now, rearrange relations for the fields in table Sony to the individual Relationship Table tables.

Upvotes: 1

Related Questions