J
Jedit
I have a database with 4 tables & 1 form.
The form is, at the moment unbound as the operators wanted to design their
form for input then have me assign the control to it, sound good?
What I want to do is take the info from the form, frmWSPOON-PLATES, & make a
new record, sounds easy but there is more, were fields txtPBNO needs to be
placed in field Batch_ID from the table tbl_Batch-No table, this is the main
table, along with field txtDate to Date Tested & ComboOpo to Employee in the
format of from form to table like the example above.
The main table tbl_Batch-No has a sub table tbl_Form-Dimns that are linked
by test_id, so there are many form dims per test ( about 5), what I want to
do here is add to this table (tbl_Form-Dimns) the contents of 10 fields from
the same form as above.
Were txtLBS1 & txtWBS1 would be entered into field Len & Wid in the
tbl_Form-Dimns table & plateNo = 1 in plateNo field.
txtLBS2 & txtWBS2 would be entered into field Len & Wid in the
tbl_Form-Dimns table & plateNo = 2 and so on till all 10 are input finishing
on txtLBS5 & txtWBS5 & plateNo = 5.
I thought this would be easier but can’t see the wo0ds for the trees for
whatever reason. Any help on how to do this would be appreciated????
The form is, at the moment unbound as the operators wanted to design their
form for input then have me assign the control to it, sound good?
What I want to do is take the info from the form, frmWSPOON-PLATES, & make a
new record, sounds easy but there is more, were fields txtPBNO needs to be
placed in field Batch_ID from the table tbl_Batch-No table, this is the main
table, along with field txtDate to Date Tested & ComboOpo to Employee in the
format of from form to table like the example above.
The main table tbl_Batch-No has a sub table tbl_Form-Dimns that are linked
by test_id, so there are many form dims per test ( about 5), what I want to
do here is add to this table (tbl_Form-Dimns) the contents of 10 fields from
the same form as above.
Were txtLBS1 & txtWBS1 would be entered into field Len & Wid in the
tbl_Form-Dimns table & plateNo = 1 in plateNo field.
txtLBS2 & txtWBS2 would be entered into field Len & Wid in the
tbl_Form-Dimns table & plateNo = 2 and so on till all 10 are input finishing
on txtLBS5 & txtWBS5 & plateNo = 5.
I thought this would be easier but can’t see the wo0ds for the trees for
whatever reason. Any help on how to do this would be appreciated????