Hello,
I have a small problem with creating a relations between two tables. Maybe you guys can help, I'll be very thankful!
I've got two tables "tblA" and "tblB" with fields:
tblA:
-Id (primary key, indexed, no duplicats). values: 1,2,3,4
tblB:
-Id(primary key)
-ElementsFromA
I'd like to create a relation between ElementsFromA and Id (tblA). The key point here is to allow multiple values so a user could assign more than one, for example elements 1,3,4 (from tblA) for each ElementsFromA from tblB.
Actually I've created a relation but I'm not sure if it's correct - there is no "+" sign in tblA datasheet view so I can't double check and confirm that elements are linked correctly.
thank you so much for your help!