We have two plant sites who's order details are slightly different then each other so we need two different order tables for each site. What we would like to have though is a master order index that feeds the two sites order tables.

So what I did is created a MasterOrderID table with one field that is autonumbered. Then I created a one to one relationship between each sites order table and the master table.

What I was hoping was that when I tried to create a new record in either one of the sites order tables a new OrderID would be pulled from the MasterOrderID table but this did not work.

I am just trying to set this up in Access 2000 first. Once I am able to complete the database structure I plan on creating a VB front end.

Could someone please tell me the best way I could accomplish this.

--
Thank You, Steve
[email protected]