Pulling correct PK
Posted: Tue Feb 08, 2005 11:55 am
I am working on a DB that will contain 3 tables
1. patients
2. house_members
3. documents
Tables 2 and 3 will have a FK from table 1
I have an initial form which inputs data into table 1. After data is entered into table it is displayed on the screen along with a secondary form. The information in this form is to be input into table 2. Upon submitting this form, the info is displyed again with another form to upload files into table 3.
The 2nd and 3rd forms are dynamic and depend on the info from the previous form.
My question is... How do I pull the correct PK from table 1 so that it can be entered as the FK in tables 2 and 3?
Its not too much of a problem if only one person is entering applications, but what if more than one are submitting to the db?
1. patients
2. house_members
3. documents
Tables 2 and 3 will have a FK from table 1
I have an initial form which inputs data into table 1. After data is entered into table it is displayed on the screen along with a secondary form. The information in this form is to be input into table 2. Upon submitting this form, the info is displyed again with another form to upload files into table 3.
The 2nd and 3rd forms are dynamic and depend on the info from the previous form.
My question is... How do I pull the correct PK from table 1 so that it can be entered as the FK in tables 2 and 3?
Its not too much of a problem if only one person is entering applications, but what if more than one are submitting to the db?