Hi there - -
Just for some background, the database is for a conversion from Microsoft Works where every customer & order is one record even if the customer has previously placed orders. In this Access database, there is one Customer record with all their orders. (Well, actually there are about 26,500 customers with about 72,500 orders.)
When a new Customer is added, I need to assign it a number – called CustKey - so that I can create a link to their Orders records. I am unable to use the Customer autonumber field because it has created conflicts when using the autonumber fields of both the Customer and Orders in other functions of the Access database.
It was easy to convert the existing Customers and assign them CustKey, and include this to their Orders records. I just need now to be able to add new Customers and assign them the next number up.
In one attempt, I created a table - LastCustKey - with one record in it – the last number assigned to the last Customer. But don’t really know how to retrieve it when a new Customer is added.
So, I guess I’m just looking for some guidance on how to approach this.
Thanks for any suggestions.
miche7
Just for some background, the database is for a conversion from Microsoft Works where every customer & order is one record even if the customer has previously placed orders. In this Access database, there is one Customer record with all their orders. (Well, actually there are about 26,500 customers with about 72,500 orders.)
When a new Customer is added, I need to assign it a number – called CustKey - so that I can create a link to their Orders records. I am unable to use the Customer autonumber field because it has created conflicts when using the autonumber fields of both the Customer and Orders in other functions of the Access database.
It was easy to convert the existing Customers and assign them CustKey, and include this to their Orders records. I just need now to be able to add new Customers and assign them the next number up.
In one attempt, I created a table - LastCustKey - with one record in it – the last number assigned to the last Customer. But don’t really know how to retrieve it when a new Customer is added.
So, I guess I’m just looking for some guidance on how to approach this.
Thanks for any suggestions.
miche7