Help with copy/add

[aftershokk]

I have a form wdriven by an underlying query with 3 tables linked.
2 of the tables are linked by id and one by zip code.

The master table has an auto id and the child table has an id field. I used the wizard to create an add record button and copy record button. When I use any of these buttons the new auto id from the master table is not populated into the child id field after clicking. How can I accomplish this?

thanks

 

[boblarson]

I have a form wdriven by an underlying query with 3 tables linked.
2 of the tables are linked by id and one by zip code.

The master table has an auto id and the child table has an id field. I used the wizard to create an add record button and copy record button. When I use any of these buttons the new auto id from the master table is not populated into the child id field after clicking. How can I accomplish this?

thanks

What you need is a form/subform with the Master / Child links set to the ID field.

 

[aftershokk]

reply

thanks

That's is what I figured but I was hoping the subform could be another screen? Can this be done and still have the copy command and add command work?

thanks Bob

 

[aftershokk]

I have the form and subform instance.
Master autonumber ID linked to ID on the child table.
When I add a record the Master ID does not appear in the Child ID field? I am baffled..
help

 

[aftershokk]

I figured out the issue but how do I make the subform only appear via a click?