S
Song Su
I want to use a form to add record to table 'Instructor'. controls on the
form are:
Name (text)
EN (integer, primary key in Instructor table)
FT_Fall (single)
PT_Fall (single)
FT_Spring (single)
PT_Spring (single)
Adjust (single)
When user click 'Add It' button, additional field not shown on the form:
SetupID = 1
WS = 0
Manually_Added = YES
1 record (all above 10 fields) will be added to Instructor table without
violating primary key.
Should I use Instructor table as unline source for the form? If so, records
always shows.
Also, what should the 'Add It' button code be?
Thanks.
form are:
Name (text)
EN (integer, primary key in Instructor table)
FT_Fall (single)
PT_Fall (single)
FT_Spring (single)
PT_Spring (single)
Adjust (single)
When user click 'Add It' button, additional field not shown on the form:
SetupID = 1
WS = 0
Manually_Added = YES
1 record (all above 10 fields) will be added to Instructor table without
violating primary key.
Should I use Instructor table as unline source for the form? If so, records
always shows.
Also, what should the 'Add It' button code be?
Thanks.