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
|
|||
|
|||
Cannot Add Record
I have a form that operates from the following query:
SELECT tblCaseInfo.*, tblStatus.ClosedDate, tblRegion.ID, tblRegion.SUBOFC, tblRegion.PM, tblRegion.PMPH, tblRegion.Ext, tblRepresentatives.*, tblAction.Actn, tblAction.NoticeDate, tblAction.Imposed, tblAction.Appeal, tblAction.Program, tblAction.Surveys, tblAction.IDROutcome, tblAction.TotalImposedAmt FROM (((tblRepresentatives RIGHT JOIN tblCaseInfo ON tblRepresentatives.ID = tblCaseInfo.RepID) LEFT JOIN tblRegion ON tblCaseInfo.FieldOfc = tblRegion.ID) LEFT JOIN tblStatus ON tblCaseInfo.CaseId = tblStatus.CaseId) LEFT JOIN tblAction ON tblCaseInfo.CaseId = tblAction.CaseID; However, when I attempt to add a record I can enter information into fields belonging to all the tables except tblAction. I get an error message when I try to enter data into the field: tblAction.Actn. It will not allow me to make an entry unless I exit the form and then reopen the form and then I am able to make an entry into the tlbAction table. Is there a problem with the query or the relationship between the tables? |
Thread Tools | |
Display Modes | |
|
|