2. ASPRunnerPro General questions
  3. Add Page
This topic is locked

Add Page

 		12/7/2007 5:36:05 PM
ASPRunnerPro General questions
C
 cordaco author

I am trying to set up an Add Page, but When I eneter the new date I'm getting the following error message:

[Microsoft][ODBC Microsoft Access Driver] You cannot add or change a record because a related record is required in table 'Agents'.
Needless to say 'Agents' is one of my forms. The particular Add Page is from an Access Query which is made up of three tables (Agents, Users & Properties).
Any one has a solution?
Sergey Kornilov admin 12/7/2007

You cannot add data to several tables at once (unless you do this manually in BeforeAdd event).
As a solution I recommend to build the Add page for the real table.