Creating my own ID

[mhemat]

Hi everyone, I have few questions and I would post them as I go along.


1- How to create my own ID numbering scheme (Key) that starts with 10020000.

2- I have 3 fields that is named "Bed", "Room", and "Location". I want to be able to when I insert a Bed number, the Room number and Location automatically appeare in their fields. For example: Bed number 1 is in room 2 and located in Robinson Hall (Location).

Thank you very much for your help.

 

[mhemat]

Hi, can anyone please help me with this.

 

[xenou]

You would have to write a function or use a query to get the max number and add one ... . Of course you will put the first ID in yourself for 10020000. After that, when you need to insert a record you will first query the table for the max ID, then add one to it and use that number as your next ID. This could be done with a DMAX() function, or a query. Some ideas were bounced around here in a tangentially related post: http://www.mrexcel.com/forum/showthread.php?t=555653

 

[SydneyGeek]

You can also use an AutoNumber field.
Create a dummy table with a Number field, and put in a number 1 less than your desired starting value.
Create an Append query and push this value to your main table, into the main ID field.
Run the query, then open the table and delete the dummy record. The next record you enter will start with the desired ID. And because it's an AutoNumber, it should increment from there.

Denis