1 form, 2 tables

  • Thread starter Thread starter HubbyMax
  • Start date Start date
H

HubbyMax

I have a form that draws info form 2 tables. I have a SELECT query that calls
for the needed cell info. The 2 tables are joined by a Dept number that is
the same in both tables, the first being Cust and the second being Cust2. My
query ties these two together making Cust = to Cust2. This worked fine, I
could call up the infor from the first table then enter the info needed for
the 2nd table. Now when I try to enter information for the 2nd table all I
get a "ding" with no ability to put any info in. Any idea what may have
happened?
 
I have a form that draws info form 2 tables. I have a SELECT query that calls
for the needed cell info. The 2 tables are joined by a Dept number that is
the same in both tables, the first being Cust and the second being Cust2. My
query ties these two together making Cust = to Cust2. This worked fine, I
could call up the infor from the first table then enter the info needed for
the 2nd table. Now when I try to enter information for the 2nd table all I
get a "ding" with no ability to put any info in. Any idea what may have
happened?
Click to expand...

Is Cust the Primary Key of its table? Do you have a Relationship defined from
Cust to Cust2? If not... the query won't be updateable.

Ordinarily (not *always* but 99% of the time) your best bet is to use a Form
for the "one" side table of a one to many relationship, with a Subform for the
"many", rather than trying to create one Great Master Query incorporating all
the tables involved.
 
Back
Top