Automation object?

[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?

 

[KARL DEWEY]

Did you also setup the Master/Child links between the form and subform?

 

[Pwyd]

yes i did. they're set correctly.

Did you also setup the Master/Child links between the form and subform?

 

[KARL DEWEY]

Try a step backwards - create a left join query using the two tables and try
adding a record in the 'many side' table.

 

[Pwyd]

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?

 

[KARL DEWEY]

You need to create a one-to-many relationship with Referential Integerity and
Cascade Update.

 

[Pwyd]

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?

 

[KARL DEWEY]

Create the queries for the forms and set the Master/Child links.