First, you are describing a one-to-many relationship, bceasue one file
record can be referenced by many people records. If this is the case, you
may wish to re-design your tablse such that a people record contains a
file_id field. You can then do away with the filespeople table
altogether.
On Wednesday, January 9, 2002, at 03:06 PM, Rick Emery wrote:
First, you are describing a one-to-many relationship, bceasue one
file
record can be referenced by many people records. If this is the
case, you
may wish to re-design your tablse such that a people record contains a
file_id
So I designed my files and people tables without any direct
relationship with one another, thinking to link them with the SELECT
statement.
What I completely forgot, up until this point, was that I would need to
INSERT these records (from pre-written HTML/PHP forms), and there is no
WHERE