Auto creation of ID

[edwardcga]

I have an application that have a main form and subform. I would like to have the application to generate the ID (the primary key and link to subform) base on the information INPUT, that is:

Year, date and class, for example I enter the date (date field), and select the class (C, M, E, K using pull down box) then the application will generate the OfferingID as example below:

OfferingID - 20140119C, 20140119M, 20140119E, 20140119K



Your advice as how to accomplish this will be greatly appreciated.

R

[ssanfu]

Before you head down this road, you should read about primary keys. I would use an autonumber field as the PK.

http://www.fmsinc.com/free/newtips/primarykey.asp
http://www.utteraccess.com/wiki/index.php/Autonumbers

You should have a field for the date and a field for the class. If you need to create an "OfferingID", you can concatenate the two fields in a query.