Relational Tables in MySQL

[dchuke]

Hello,
I have three MySQL tables in a database and they are supposed to be of a one-to-one relationship, such that each record in each table is unique, and each line in all three tables are for the same record. i.e. a record on table 1 line 1 is part of a record on table 2 line 1 which are part of a record on table 3 line 1.
The reason for three seperate tables was that the input process is dynamic from three web forms. Each form has its own "submit" button and so the tables get filled one after the other. I need to be able to relate each table to the other such that a primary key in table 1 gets populated in the corresponding line in tables 2 and 3 as a foreign key. So when search queries are run, it will be possible to successfully "JOIN" matching records from all tables.

If further clarification is required, I will be happy to provide this. BTW I am using DreamweaverMX 2004 as my web building tool and then uploading the updated files into my site located on a web hosting server. The MySQL tables are, of course, also on this server.

Regards,
D

[HardCoded]

This belongs in the database forum, but here goes:

(Vanilla) MySQL is not relational in that sense. It does not have the concept of foreign keys. You have to build these into your app for when you do inserts.

You'll probably be excited about this:
http://ca3.php.net/function.mysql-insert-id

[DmmH]

Originally Posted by HardCoded

This belongs in the database forum, but here goes:

(Vanilla) MySQL is not relational in that sense. It does not have the concept of foreign keys. You have to build these into your app for when you do inserts.

You'll probably be excited about this:
http://ca3.php.net/function.mysql-insert-id

this might come a bit late, but the INNO-DB table type does support relational tables actually ;)