G
guat
Hi, I'm not sure if this has been answered, but I need some help.
I have a database with a table for employee demographic information, with
their ID number, address, etc. I also have a table for a standard list of
allowances for each employee. I have made a tabbed form that asks to fill in
the demographic information, and then on the third page, I am trying to have
the user select from the list of allowances using a check box. From what
they select, I would like that information placed into another table storing
each allowance as a separate record using the employee id.
I'm trying to figure out where to put the check box - and how can I get it
to update the third employee allowance table, and what if they check the box
2times, will it make duplicate records? And what if they want to delete an
allowance? If it's on that separate table, how can I get it deleted from
there using the same tabbed form?
Does this makes sense? I think I have gotten myself into something that I
don't know how to complete.
Varvara
I have a database with a table for employee demographic information, with
their ID number, address, etc. I also have a table for a standard list of
allowances for each employee. I have made a tabbed form that asks to fill in
the demographic information, and then on the third page, I am trying to have
the user select from the list of allowances using a check box. From what
they select, I would like that information placed into another table storing
each allowance as a separate record using the employee id.
I'm trying to figure out where to put the check box - and how can I get it
to update the third employee allowance table, and what if they check the box
2times, will it make duplicate records? And what if they want to delete an
allowance? If it's on that separate table, how can I get it deleted from
there using the same tabbed form?
Does this makes sense? I think I have gotten myself into something that I
don't know how to complete.
Varvara