Copy records from a second table

D

Derek

On the main form I have a duplicate or copy button. This
copies the current records by means of an append query and
appends it to the underlying table and moves the focus on
the form to the new appended record. This allows the
customer to copy a record and make the minor changes
required. But there are other associated record from
another form and table that also need to be copied in a
simular way. There is referencial integraty between the
two tables that prevent me using an append query.
Help!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top