Have a main ID # (primary key) and then create multiple sub ID's under the main ID (ex. ##-01, ##-02

[Jenni_Velting]

I have create a table with a list of projects, where the Project ID # is an auto number and is the primary key in the table. I would like to have a second table that holds individual tasks associated with each project. I am trying to have the Task ID = the Project ID and then -01, -02, -03, etc. consecutively for each project ID as new task records are created. Can someone help me to do this?

[pbaldy]

The most common solution is probably the DMax() method mentioned here:

http://www.baldyweb.com/CustomAutonumber.htm

In your case, the criteria would be on project ID. Also, I would only save the second part, since presumably the project ID is already a field. You can concatenate them for the user.