First database-5 tables linked by autonumber ID--
Since an Autonumber is a meaningless, uncontrollable unique key, it
makes NO sense to link two tables autonumber to autonumber. You have
absolutely no way to know that the record in TableA with autonumber
value 312 has anything whatsoever to do with the record in TableB with
value 312; generally, since autonumbers are assigned in the order of
data entry and will usually have gaps, you can be pretty sure that the
two records will NOT be relevant to one another.
What are these five tables? What real-life Entity (person, thing, or
event) does each table represent? How are those real-life entities
logically related?
this shows up in
relationships-form is designed using fields from each of these tables-Form
will not autonumberin brackets in just says autonumber nor does it save data
to the appropriate table--it does save it in form database view-If I fill in
data on the table datasbase view it works fine but just for that given
table--thanks in advance
There is no such thing as "form database view", and a five-table
joined query (even if it had correct join fields, which you apparently
don't) will not usually be updateable. Typically you will have several
one-to-many relationships, joining the Primary Key of the "one" side
table (which might or might not be an Autonumber) to a "foreign key"
field, NOT the Primary key and certainly *not* an autonumber, in each
Child table. For data entry you would base a Form on the "one" side
table with one or more Subforms based on the "child" tables.
John W. Vinson[MVP]
