create duplicate records



I have created a form for a contract database. This form allows the user to
enter in all the terms of the contract. One thing that I'm having a problem
with is secondary vendors. A contract will list which vendor #'s are to be
included and which vendor numbers should be excluded. I have all of the
contract data going into a single table. I've also created a 2nd table to
store a copy of the Agmt_#, Vend_ID, Agmt_Status, Eff_date, &
Secondary_Vend_ID. I want to know if it's possible for the user entering in
the information to enter all of the secondary vendors on the original form
and have it create a new record for each secondary vendor in the 2nd table.

I'm not sure if this makes sense, but hopefully it will.




The correct method is to use a subform with your second table as the record
source for the subform.

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