Unique ID

[claddagh]

Hi guys,

Just a quick one I`m hoping you can help me with.

I am just about to start a new DB, but there are a few things I need to sort before i start.

I am working with a quotation system etc which will require the use of unique IDs...

eg 000123 then 000124 etc, this bit is not a problem.
The thing I would like to know how to do is when someone makes an order, I would like the quotation number to be changed slightly to add more detail.
For eg, If the quotation number that is allocated is 00123 and they then order a Conservatory, I would need to have this 00123 become 00123CNS, but this can be in a seperate field, Which I would need anyway.

The question is, How Would I go about this.
I have a table that describrives the product, TBL_PRODUCTS; ID, Product_Type, Product_ABBR

Product_Type = for e.g Conservatory
Product_ABBR = for e.g CNS

I would need the ref number and product abbr combined to create an order number.
[note] There will be a check box to say of ordered ot not, so I assume there will be an If statement somewhere ????

I hope I have made myself clear, if not, please as what you need to know.

Thanks in advance for any help

 

[ColinEssex]

You don't need to do it when the order is raised. If you have the order No and the product code on the orders form then thats ok.
When the order is confirmed and you create (for example) an invoice, or some confirmation print out, thats when you can concatonate the 2 fields together in the query that supplies the invoice, this will then give you the complete order number as you described.

Col

 

[claddagh]

Should work

Colin,

Looking into what you have said, that looks as though it should work fine.
I`ll have to test to see if this would be the case, but I dont see why not.

Thanks for the info

Max