2 order types 1 table

B

Brook

Good Day,

I am trying to create a table that will hold my master inventory, however I
have two types of orders: Custom and Stock. For my custom orders I would like
to have a custom order number KI-0000 (then incremental with each new order..
KI-0001, KI-0002, etc), and Stock Orders NW-0001 (with incremental numbering
same as above.

I am unsure how to incorporate the two types of orders into one table, does
anyone have any ideas? Tips? tricks that they could share?

Thanks,

Brook
 
N

Nikos Yannacopoulos

See my reply in the Access (general) NG.

P.S. In the rare occasion when there is a real need to cross-post, so so
by posting once with multiple NG names in the To box, rather than
posting to each NG separately (which is actually a multi-post).
Cross-posting has the added advantage that an answer posted in one NG
appears in all.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CrossPost: 2 Order Types 1 Table 1
Incremental Numbering 2
Sequence numbering of documents 2
Single Table / Multiple Inventory Order Numbers 5
Access 2007 0
mastertable for orders/different order numbers 3
Hard to explain -- two types of ItemID's one table 3
FIFO Help 10

Top