Access 2000 database design - Query fails on adding a third table

[Guest]

When I query the the central project table to allow entry of multiple contact
information, the query fails. I.E. The query is only successful when adding
ONE contact's information... the database is not working!

The project table primary (text) key is: ProjectId. The four contact tables
are keyed with unique autonumber IDs related to four unique foreign (number)
keys in the Project Id table.

What am I missing?

 

[tina]

so you have four different tables for contacts (why four? what makes the
contacts different enough to *require* putting them in different tables?)
and one table for projects. i'd think that the projects table would be the
parent, and each contacts table the child, in a parent-child relationship.
but your description sounds like the contacts tables are the parent tables,
each related to the child projects table. is that correct?

at any rate, why are you trying to link the tables in a query in order to
add contacts to a project? the standard form setup would be parent table
bound to a main form, and child table bound to a subform - linked by the
primary/foreign keys in the two tables. i've only occasionally seen a
situation where it was advantageous to link parent and child tables in a
single query and bind that to a single form.

hth