Access 2007 - relationship
Posted on 2011-02-17
I am at a loss in setting up the following design.
My OS is windows 7.
I have a main table called tblContacts, and one of the fields is called 'Responsible for'.
There is another table called tblResponsible4' which has only 2 fields, 1 is an ID and the other called Resp4.
One contact can be responsible for more than 1 item. But there is only 1 field on the main table called 'Responsible for' to capture the data which is entered via Form using a combo box. Would I need to duplicate the record and then enter the new data for the 'Resp 4'
eg : Mr. A is responsible for 'Food' and 'Drinks'
or even more than 2 or just only 1 item.
Hope someone can send me a simple design of how this is achieved. thank u.