One to multiple records problem
I have a table Model, with fields Factory, Model and Email
Because One factory produces more than one model in most cases, I got multiple records with same factory code while differenct model number. And every factory has one email contact, my question is:
How can i enter email address only one time for each factory, and I can demonsrate this email address associated with factory on table Model?