Page 1 of 1

Autonumber and relationship

Posted: Tue Feb 24, 2004 9:17 am
by szms
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?

Posted: Tue Feb 24, 2004 5:44 pm
by AVATAr
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.

Posted: Thu Mar 25, 2004 8:28 am
by szms
A moke up would be very helpful for implementing my datavase.

Posted: Thu Mar 25, 2004 8:35 am
by timvw
Usefull mysql_function LAST_INSERT_ID;

Posted: Thu Mar 25, 2004 8:48 am
by szms
I am trying to implemant this database using MS Access. Thank you.

Posted: Fri Mar 26, 2004 5:37 am
by timvw

Posted: Fri Mar 26, 2004 7:38 am
by magicrobotmonkey
i think this is a php forum

Posted: Fri Mar 26, 2004 7:43 am
by patrikG
magicrobotmonkey wrote:i think this is a php forum
?

Posted: Fri Mar 26, 2004 7:58 am
by magicrobotmonkey
access isnt php

Posted: Fri Mar 26, 2004 8:00 am
by patrikG
mySQL isn't either, nor is Oracle, SQLite, FoxPro etc. etc., but PHP can interface with all of them (and more).

Posted: Fri Mar 26, 2004 8:10 am
by magicrobotmonkey
yea but hes not asking how to interface php with it

Posted: Fri Mar 26, 2004 8:16 am
by patrikG
I don't see anything indicating that he is not.

I suggest we leave it at this, magicrobotmonkey, so the thread doesn't get derailed any further.