Autonumber and relationship
Posted: Tue Feb 24, 2004 9:17 am
I am dealing with 3 tables; Child, Guardian and Link. Here is the field that I am using for those tables.
Child: Child_ID(PK & autonumber), ChildName (Text)
Guardian: Guardian_ID(PK & autonumber), GuardianName (Text)
Link: Child_ID (FK & number), Guardian_ID (FK & number)
As you can see that I am trying to implement many to many relationship.
Now I want to insert data (using form in MS Access) in such a way so that Link table can be filled up by itself. That means my form will be shown only ChildName and GuaridanName. How to do that?
Child: Child_ID(PK & autonumber), ChildName (Text)
Guardian: Guardian_ID(PK & autonumber), GuardianName (Text)
Link: Child_ID (FK & number), Guardian_ID (FK & number)
As you can see that I am trying to implement many to many relationship.
Now I want to insert data (using form in MS Access) in such a way so that Link table can be filled up by itself. That means my form will be shown only ChildName and GuaridanName. How to do that?