Hello Everyone.
Situation:
I have about 10 staff looking after parts on aircraft. Each staff member has there own computer joined by a wirless network. Each staff member looks after 5 aircraft with 1 excel file representing 1 aircraft.
Problem:
When working with each aircraft we add remove parts frequently. I would like each part added to an aircraft to be assigned a unique tracking number. Therefore due to the fact that the tracking number needs to be available to multiple users of different computers I am guessing the tracking number needs to come from an external source.
I dont want to OPEN an excel file and get the tracking number because the excel files are taking along time to open accross the network.
So basically when a new part is added I would like to get the next tracking no available for it and update the external source to show the next available tracking number.
Can anybody suggest the best way to go about this, and the best external soure ie perhaps a excel file (remains closed), txt file or access database???
Thanks in advance for any help.