Hi all.

It is my first post here since I started learning Access from the Access Bible book. Putting it simple: I’m an absolute beginner.

I’m building a database to help me in my work. We sell three basic types of references and we have classified them by three letters: L, S and U. A client (with is data stored in a table) makes an order (6 digit number and related data stored in a second table) and that order includes one or more of those three products. But they must be numbered sequentially and that is what I cannot define

Example:
Order 010234, 2 references:
-L0124
-L0125

Order 024568, 3 references:
-U0023
-S1253
-L0126 <- this one must be sequential when I choose "L" in the type of ref on the appropriate field.

Next order:
-U0024
-S1254
-L0127

The data for each reference is stored in a third table. So, is it possible to have a key field in this third table auto numbered according to the sequence? Or am I defining the whole thing wrong?

Thx all.