W
Wayne Smith
Applies to Access 2000, FrontPage 2000, IIS 5.1 on XP Pro
I have created two tables in an Access database as follows:
Table 1 - Registration:
userName: Text (Primary Key)
Password: Text
Table 2 - Personal
ID: AutoNumber (Primary Key)
firstName: Text
lastName: Text
address1: Text
address2: Text
towncity: Text
county: Text
postcode: Text
telephone: Text
mobile: Text
email: Text
dateofbirth: Text
I have created a Relationship from the userName Field in the Registration
Table to the ID Field on the Personal Table (the two Primary Key Fields)
I then created two asp web pages in FrontPage using Text Boxes to represent
each of the above Fields and made sure the length was correct and each was
linked up to the correct Table Field in the database.
The problem occurs when I open Registration.asp and enter a userName and
Password and click the submit button, it takes me to the Personal.asp web
page and I then complete all the fields for that table and click the Submit
button again, but when I open the Access database to check that the data was
captured, the following occurs:
Data is captured correctly into the Registration Table and if I click the
little Plus Sign to the left of the data, it opens up the fields for the
Personal Table but no data has been captured, and even if I open the
Personal Table separately in the database, no data is present and I cannot
understand why?
Can anybody see something obvious that I may be doing wrong, I'm certainly
not an expert with Access but I thought it would be a fairly simple and
straight forward task to just link two tables and capture data through an
..asp web page correctly.
Any help or guidance would be greatly appreciated.
Kind Regards,
Wayne
I have created two tables in an Access database as follows:
Table 1 - Registration:
userName: Text (Primary Key)
Password: Text
Table 2 - Personal
ID: AutoNumber (Primary Key)
firstName: Text
lastName: Text
address1: Text
address2: Text
towncity: Text
county: Text
postcode: Text
telephone: Text
mobile: Text
email: Text
dateofbirth: Text
I have created a Relationship from the userName Field in the Registration
Table to the ID Field on the Personal Table (the two Primary Key Fields)
I then created two asp web pages in FrontPage using Text Boxes to represent
each of the above Fields and made sure the length was correct and each was
linked up to the correct Table Field in the database.
The problem occurs when I open Registration.asp and enter a userName and
Password and click the submit button, it takes me to the Personal.asp web
page and I then complete all the fields for that table and click the Submit
button again, but when I open the Access database to check that the data was
captured, the following occurs:
Data is captured correctly into the Registration Table and if I click the
little Plus Sign to the left of the data, it opens up the fields for the
Personal Table but no data has been captured, and even if I open the
Personal Table separately in the database, no data is present and I cannot
understand why?
Can anybody see something obvious that I may be doing wrong, I'm certainly
not an expert with Access but I thought it would be a fairly simple and
straight forward task to just link two tables and capture data through an
..asp web page correctly.
Any help or guidance would be greatly appreciated.
Kind Regards,
Wayne