3 tables and one serial to rule

[ronhj]

Hi everyone,

I have 3 tables in a database, what i want to do is to make sure that when data is enetered into either one of the 2 other tables, a serial number is auto-generated that will never be the same. now the tricky part. Whenever new data is entered into either one of these two tables it will automatically create a record in the last 3rd table matching to the unique serial number auto generated in the other.

Basically im trying to keep track of product information from 2 differrent suppliers and then combine them into one master product table. am i going about this the wrong way? please help ive been at this for 2 weeks and its driving me nUtS

[Ender]

am i going about this the wrong way?

I think so.

You should keep all the Products in the same table. You can differentiate between different Supplier's Products by using a Supplier field. That can then be used to filter Finds and relationships as necessary.