Good day all. First post... here it goes.
I will have 1 form where multiple "Stages" of information will be added.
Each "Stage" will have a unique number (1,2,3,3a,4,5...) followed by multiple cells of data related to that 'Stage'
ie: FORM1
STAGE 1, FROM: xx TO: XX DELTA: yy TYPE: zz NAME:bb DATE: cc
STAGE 2, FROM: xx TO: XX DELTA: yy TYPE: zz NAME:bb DATE: cc
STAGE 3, FROM: xx TO: XX DELTA: yy TYPE: zz NAME:bb DATE: cc
STAGE 3A, FROM: xx TO: XX DELTA: yy TYPE: zz NAME:bb DATE: cc
STAGE 4, FROM: xx TO: XX DELTA: yy TYPE: zz NAME:bb DATE: cc
What I would like to happen on 1 save command is to save all above data to 1 table but in multiple rows based on the "Stage No."
So the table rows will end up looking like the above (The form itself will not be set up in rows as above).
The table will only include the headers "Stage No., From, To, Delta, Type, Name, Date"
Basically it is a...
If the Stage number is unique from the others enter the data in the next blank row.
I hope this makes sense....
Bookmarks