I would like to enter record data on a form and have relevant records populate in a different form.
My tables are as follows
Agents - MyIMOs - Contracting - MyCarrier - My Products
The Contracting table holds the product level information as well as compensation percentages.
I would like to be able to enter in a new contract and it creates the products based on the Information I've entered.
I would like to keep the Contracting separate as each agent has different contracts available. an Agent can have multiple contracts but a contract can have only 1 agent.
How am I able to create a New Contract AND a New Item based on the information I entered in the New Contract Form?
Agents - MyIMOs - Contracting - MyCarrier - My Products
The Contracting table holds the product level information as well as compensation percentages.
I would like to be able to enter in a new contract and it creates the products based on the Information I've entered.
I would like to keep the Contracting separate as each agent has different contracts available. an Agent can have multiple contracts but a contract can have only 1 agent.
How am I able to create a New Contract AND a New Item based on the information I entered in the New Contract Form?
