maddog1111
New member
- Local time
- Today, 14:33
- Joined
- Feb 10, 2016
- Messages
- 2
Hello,
I am after a solution that will let me use a form to perform a batch data entry into a single table.
Example
Site: 123456
Serial: 78945
Date: 08/02/2016
Multi: Y
Serial_2: 99565
Serial_3: 54554
Serial_4:
What I am trying to achieve is where Multi = Y it will create an entry for Serial and then another entry for Serial_2 (but it populates Serial and blanks out Serial_2) and the same for Serial_3
attached is the example I am trying to achieve using a single form.
I am after a solution that will let me use a form to perform a batch data entry into a single table.
Example
Site: 123456
Serial: 78945
Date: 08/02/2016
Multi: Y
Serial_2: 99565
Serial_3: 54554
Serial_4:
What I am trying to achieve is where Multi = Y it will create an entry for Serial and then another entry for Serial_2 (but it populates Serial and blanks out Serial_2) and the same for Serial_3
attached is the example I am trying to achieve using a single form.