update query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Sometimes, I cannot add a new record (in general update) to a query and/or
form that link to that query. (It takes the values two different tables).
What can be the reason. How can I add a new record.
 
Hi,


Can be many reasons. If the problem occur only "some times", meaning
that it work "in the other times", then it is probably either a validation
rule of a field ( a value is required but not supplied, a value >= 0 is
required, but negative, etc. ) a validate of the record (like if you imposed
that endingTime >= startingTime in the table design, and the actual value do
not pass the test), or a referential integrity rule (like a parent-child
relation where the parent must be already known in table of parents, before
using it in the junction table of parentsAndChildren).


Hoping it may help,
Vanderghast, Access MVP
 
Back
Top