If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
1 form, 2 tables
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] |
Thread Tools | |
Display Modes | |
|
|