Hi all,
Im putting together a dbase which I'd like to auto generate a part number out of roughly 5 fields, they will all be drop down lists.
eg
Green
Large
Wide
Hairy
Cheap
To give part number GLWHC_001 and incrementally counted up for each occurance of the same combination. I need to keep it independant from the auto record numbering if possible.
If anyone has any ideas that would be very helpful as I really cant rely on the autonumber because I need to place the part number on the item and visually identify it from that number at a glance..
Cheers