Originally Posted by
ShaunG
I thought I had it sussed but maybe not so much....
I want to create an Order number which automatically populates when a new order form is opened.... but the tricky part is im trying to keep this number as small as I can while combining, not adding the - Job Number, UnitID, and ItemID = Order Number.
We can have Multiple units per Job and Multiple Items per Unit, but not more then 100 for either.
every new Job Number Im trying to get the UnitID To start at 1 and every New UnitID to start at 1 also.... otherwise the order Number will get massive real quick, also I im trying not to add the number together I want to combine it.
example - Job Number 1112, UnitID 1, and ItemID 1 = 1112001001 the reason for combining and not adding is you can use the number to work out which job, unit and order it is for.
is this the best way to achieve what I want.... or is there a better way to get an order number that wont repeat itself and is small.
this is what I thought
=[tblJobDetails]![JobNumber]*100+[tblJoineryUnit]![UnitID]*100+[tblOrders]![ItemIID]