-
Special auto numbering...
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.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|