Query that is updatable

  • Thread starter Thread starter Annelie
  • Start date Start date
A

Annelie

This is so simple, but it does not work. I work mostly with imported data.
But I had one field (EstimatedCosttoComplete) in my table budget, where I
could add data manually. Of course after each import, my one field is blank
because the import wipes it out. So I put it into a separate table, which
has only two fields, JobNo and EstimatedCosttoComplete.
When I join the two table by JobNo
LEFT JOIN TblCosttoComplete ON Budgets.JobNo = TblCosttoComplete.JobNo
I cannot add data. I tried all kind of joins, but I can't get it to let me
add data.
Help
Annelie
 
LEFT JOIN TblCosttoComplete ON Budgets.JobNo = TblCosttoComplete.JobNo
I cannot add data. I tried all kind of joins, but I can't get it to let me
Click to expand...

Be sure that JobNo has a unique Index (such as a Primary Key) in both
tables.
 
Is the JobNo field from TblCosttoComplete in the field list for the query
(part of the SELECT list)?
 
JobNo was not a primary key in TblCosttoComplete, after changing that, I can
enter data.
Thank You,
Annelie
 
Back
Top