1 form, 2 tables

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?

On Tue, 27 Oct 2009 17:34:02 -0700, HubbyMax
wrote:

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?

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.
--

John W. Vinson [MVP]