Autonumber and relationship
Moderator: General Moderators
Autonumber and relationship
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?
- AVATAr
- Forum Regular
- Posts: 524
- Joined: Tue Jul 16, 2002 4:19 pm
- Location: Uruguay -- Montevideo
- Contact:
well..
what do you mean with "I want to insert data (using form in MS Access) in such a way so that Link table can be filled up by itself" ?
make a form... populate two combobox with the child and the guardian...
(search the forum for how to populate a combo.. here you have some reference viewtopic.php?t=7113&highlight=combobox )
then just insert both ids (fetched form de $_POST.
what do you mean with "I want to insert data (using form in MS Access) in such a way so that Link table can be filled up by itself" ?
make a form... populate two combobox with the child and the guardian...
(search the forum for how to populate a combo.. here you have some reference viewtopic.php?t=7113&highlight=combobox )
then just insert both ids (fetched form de $_POST.
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA
-
magicrobotmonkey
- Forum Regular
- Posts: 888
- Joined: Sun Mar 21, 2004 1:09 pm
- Location: Cambridge, MA