C
Chad
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.
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.