Form to Update Two Database Tables with One-To-Many Relationship

[Tony Scarola]

Hello everyone. I apologize for this newbie question but after searching the
'net I am at a loss.

I have a database with two tables. The first, table 1, is for the user
information and the second, table 2, is for the type of cars they have - so
one user can have multiple cars. These are linked with a one-to-many
relationship by one field:

Table1 - Users
--------
ID (autonumber)
Field1 (text)

Table2 - Cars
--------
TableID (autonumber)
Table1ID (number, linked to ID of table 1)

I have a query that is used to display the records appropriately and this
also works great on the ASP page.

I need assistance creating a submission form that will allow the data to be
entered properly - i.e. one user with multiple cars. Has anyone done
something like this in FrontPage? I assume this would be a custom data entry
form since FrontPage data for wizards will only allow updating one table.
Any code samples would be greatly appreciated.

Thank you in advance.

 

[Stefan B Rusynko]

Do it w/ 2 separate pages/forms
Have them create their "data" record and then on another page add their cars to the other table

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hello everyone. I apologize for this newbie question but after searching the
| 'net I am at a loss.
|
| I have a database with two tables. The first, table 1, is for the user
| information and the second, table 2, is for the type of cars they have - so
| one user can have multiple cars. These are linked with a one-to-many
| relationship by one field:
|
| Table1 - Users
| --------
| ID (autonumber)
| Field1 (text)
|
| Table2 - Cars
| --------
| TableID (autonumber)
| Table1ID (number, linked to ID of table 1)
|
| I have a query that is used to display the records appropriately and this
| also works great on the ASP page.
|
| I need assistance creating a submission form that will allow the data to be
| entered properly - i.e. one user with multiple cars. Has anyone done
| something like this in FrontPage? I assume this would be a custom data entry
| form since FrontPage data for wizards will only allow updating one table.
| Any code samples would be greatly appreciated.
|
| Thank you in advance.
|
|
|

 

[Stefan B Rusynko]

See http://support.microsoft.com/default.aspx?scid=268948

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
To find the best Newsgroup for FrontPage support see:
http://www.frontpagemvps.com/FrontPageNewsGroups/tabid/53/Default.aspx
_____________________________________________


| Hello everyone. I apologize for this newbie question but after searching the
| 'net I am at a loss.
|
| I have a database with two tables. The first, table 1, is for the user
| information and the second, table 2, is for the type of cars they have - so
| one user can have multiple cars. These are linked with a one-to-many
| relationship by one field:
|
| Table1 - Users
| --------
| ID (autonumber)
| Field1 (text)
|
| Table2 - Cars
| --------
| TableID (autonumber)
| Table1ID (number, linked to ID of table 1)
|
| I have a query that is used to display the records appropriately and this
| also works great on the ASP page.
|
| I need assistance creating a submission form that will allow the data to be
| entered properly - i.e. one user with multiple cars. Has anyone done
| something like this in FrontPage? I assume this would be a custom data entry
| form since FrontPage data for wizards will only allow updating one table.
| Any code samples would be greatly appreciated.
|
| Thank you in advance.
|
|
|