Using Custom Autonumber

[speakers_86]

Alright, I'm almost done for a while, but a few parting questions. I'm working on a project with particular rules about the primary keys. Of course, I'm using autonumbers, but the end user doesnt need to know that! There are two parts to the custom numbering. A series and a suffix. It will look something like 01-001. I've been treating each part as text, I don't know why, it just sounded right. But now I'm to the part where I need access to generate numbers itself. So how can I get the series to be in the format of XX and the prefix to stay like XXX? Also, how do I make a new value be max+1? I believe I've seen people here put a formula in the tables for default value, something like max()+1. I played with that a little, but I'm calling it quits for the night. Oh, and I'm sure I'll need to change it to number format too.

I've never tried making custom numbering fields like this, I've never really had a need. So thanks for any help.

 

[GinaWhipp]

The DMax() you refer to goes in the Form not at the table level. And just so I get this right is that value stored in one field or two seperate fields?

 

[speakers_86]

Two separate fields, two different tables even.

 

[GinaWhipp]

Huh? Are you saying your ID is in two seperate tables? So you want DMax() to work across two seperate tables?