Hi,
I am using Access 2010
We have 3 plants that use the same access D/B. The plants are 22, 33, 44. We have a generic form that launches where operators from each plant can input their samples daily.
Example:
operator from plant 22 will log in their samples as 22-101, 22-102, 22-103...