HeadAgainstABrickWall2021
Member
- Local time
- Today, 15:11
- Joined
- Sep 23, 2021
- Messages
- 32
Hi all,
I am trying to set up sequential numbering for my CustomerID field in tblCustomer (first and highest table in database). Much as I would love to let it stay as an autonumber, I have been directed by management that CustomerIDs must be sequential with no gaps. As such I have established a separate autonumber field as my primary key in tblCustomer. I want/need to use field CustomerID as my foreign key in subsequent tables.
I have tried multiple ways to set this up using DMax with no luck. What I am looking for is:
1. Use opens 'Add Customer' form. All fields are blank.
2. Person types surname/firstname/date of birth. On confirmation that this combination is not already in database, generate max user ID +1 in CustomerID field on form.
3. On click 'save' button, save all fields to tblCustomer.
Only one person at a time will be using this database, so I don't have any concerns with clashing data entry resulting in duplicates/error.
Any help is appreciated!
I am trying to set up sequential numbering for my CustomerID field in tblCustomer (first and highest table in database). Much as I would love to let it stay as an autonumber, I have been directed by management that CustomerIDs must be sequential with no gaps. As such I have established a separate autonumber field as my primary key in tblCustomer. I want/need to use field CustomerID as my foreign key in subsequent tables.
I have tried multiple ways to set this up using DMax with no luck. What I am looking for is:
1. Use opens 'Add Customer' form. All fields are blank.
2. Person types surname/firstname/date of birth. On confirmation that this combination is not already in database, generate max user ID +1 in CustomerID field on form.
3. On click 'save' button, save all fields to tblCustomer.
Only one person at a time will be using this database, so I don't have any concerns with clashing data entry resulting in duplicates/error.
Any help is appreciated!