Bob Powell
<Does anyone know how to auto-generate a unique column that
allows me to always have a specific text string in front of
it?>
Bob,
I've got a client that has four warehouses. In each warehouse he has the
same item numbers but he wanted to keep the balance on hand for each
warehouse for each item. To make a unique number in the inventory table I
combined the invitemno and warehno into a column (idkey) and ruled it as
having to be unique. So I could update the on hand column as they sold and
received those items. He has around 16,000 items in each warehouse.
the expression used is (invitemno+warehno) for the that computed column.
example:
invitemno = 'D12304'
Warehno = '1'
idkey = 'D123041'
You may need to set up a column with 'hot' in it and have another column
with the '234' in it! then your computed column would combine those two
column and would show 'hot234'.
Best regards,
Oma Cox
