Garcimat
Member
- Local time
- Tomorrow, 03:38
- Joined
- Jun 7, 2022
- Messages
- 67
Hi guys
I need help, I have a table with “SWO’s” it is like a work order…. Under one specific SWO I can have many “PTF’s” it is a secondary working order under the primary working order “SWO”. On my input form I have a field for the “PTF NUMBER” I want this field to be automatic, so it will eliminate user input errors.
I need a instruction or query that will search my master data table find the SWO number, find the last/highest PTF NUMBER under that SWO and fill the “PTF NUMBER” field with last number + 1
I have managed to find the highest PTF NUMBER with a query… I am trying not to use too much SQL, I like to keep everything in VBA.
thank you in advance
I need help, I have a table with “SWO’s” it is like a work order…. Under one specific SWO I can have many “PTF’s” it is a secondary working order under the primary working order “SWO”. On my input form I have a field for the “PTF NUMBER” I want this field to be automatic, so it will eliminate user input errors.
I need a instruction or query that will search my master data table find the SWO number, find the last/highest PTF NUMBER under that SWO and fill the “PTF NUMBER” field with last number + 1
I have managed to find the highest PTF NUMBER with a query… I am trying not to use too much SQL, I like to keep everything in VBA.
thank you in advance