J
jon cosby
I'm trying to design a form allowing employees to sign up for available
time slots. A schedule will later be created based on these available
times. The main form will show the employee in columnar form. The subform
will display all time slots in tabular form, with checkboxes for the
employee to indicate availability. On checking the box, a new entry will
be made in the Available table with that employee's id and the slot number.
Tables:
Employees
EmpID
FirstName
LastName
Slots
SlotNumber
Day
Time
Available
EmpID
SlotNumber
I'm stumped. This can't be done in the wizard as the Employee and slot
tables are not linked. What I'm trying to do is design the forms
seperately and link the checkbox with a SQL insert. Is this possible? I
can't see how it would be done, but maybe somebody has a suggestion.
Jon
time slots. A schedule will later be created based on these available
times. The main form will show the employee in columnar form. The subform
will display all time slots in tabular form, with checkboxes for the
employee to indicate availability. On checking the box, a new entry will
be made in the Available table with that employee's id and the slot number.
Tables:
Employees
EmpID
FirstName
LastName
Slots
SlotNumber
Day
Time
Available
EmpID
SlotNumber
I'm stumped. This can't be done in the wizard as the Employee and slot
tables are not linked. What I'm trying to do is design the forms
seperately and link the checkbox with a SQL insert. Is this possible? I
can't see how it would be done, but maybe somebody has a suggestion.
Jon