Multiple same fields containing different information
I have an opportunities table, where a person can create a potential opportunity in the business. I also have a customer table (which is connected to a contact table, a customer can have many contacts).
The opportunities and customer table has a many to many relationship, an opportunity can have many customers, and a customer can have many opportunities.
In my opportunities table, I have been able to input a lookup field which allows the user to select a customer (and then a contact under that customer).
However, because an opportunity can have many customers, I will need several lookup customer (and contact) fields. I have replicated the fields, and they seem to work when I am inputting information in to the form, however when I save the opportunity it is displaying all of the customer and contact fields as the same customer and contact. How can I get these lookup fields to save separate data from the customer table?
Thanks,
Rosie
The opportunities and customer table has a many to many relationship, an opportunity can have many customers, and a customer can have many opportunities.
In my opportunities table, I have been able to input a lookup field which allows the user to select a customer (and then a contact under that customer).
However, because an opportunity can have many customers, I will need several lookup customer (and contact) fields. I have replicated the fields, and they seem to work when I am inputting information in to the form, however when I save the opportunity it is displaying all of the customer and contact fields as the same customer and contact. How can I get these lookup fields to save separate data from the customer table?
Thanks,
Rosie
