2 order types 1 table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top