Repeating Serial Numbers
I have been trying to figure out a way to relate contacts to company in a many to many relationship and have created the join tables. However, I have the following problem:
I have 3 contacts for each company. The table "Contacts" has their contact info. I have a "Company" table which already has a portal to the Contacts table. The problem is that for every new record I create in the Contacts table, the serial number is auto-entered so it increases and the company changes when I need 3 records on the Contacts table for each record on the Company table.
Is there a way to auto enter 3 repeating serial numbers and increase them. For example, in the Contacts table, this would be 1- 1- 1 (3 records in the database) then 2- 2- 2 ( 6 records in the database) and then increases upto 600-600-600 ( for example)?