Automation object?

  • Thread starter Thread starter Pwyd
  • Start date Start date
P

Pwyd

I have a form with a subform on it. Each field is run from a table, and the
table parent has an autonumber field, which is linked to the child field in
the relationships window. The child field is a "number" field. When i go to
create a line on the subform, it gives me an error about an automation object
not being present. Can a form/subform with a one to many relationship not be
set up this way?
 
Try a step backwards - create a left join query using the two tables and try
adding a record in the 'many side' table.
 
Right now there's no enforced referential integrity.

How does access associate one set of records with another? pointers? or do
i need to do it manually with a query?
 
You need to create a one-to-many relationship with Referential Integerity and
Cascade Update.
 
Okay. but when you build the subform onto the form. you don't have to do
anything for it to operate on its own. You needn't say, build a query thats
based on the thing that links the two tables, it does that on its own?
 
Back
Top