storing choice's in a table ( newbe alert )

[stuartam]

Can someone shed some light on how I might achieve this ( ive got quite a few books now, but I cant work it out ).

I have a form with the following:

a combo box containing a list of users
4 check box’s ( will be adding more in time )

When the user checks the 1st check box it stores there user name in one field in the table, then the user check’s the 2nd check box it stores there user name in a different field in the table, and so on.

Eventually I also want to be able to add the ability to story the date / time that the check box was checked for each of the check box’s (now that’s not proper English is it )

Any help would be great.

Best regards

 

[pbaldy]

That can certainly be done, but can you elaborate on what you're trying to accomplish here? The need for multiple checkboxes and associated fields hints that maybe there's a better way to design the table(s).

 

[stuartam]

hi thanks for the reply, this is what i want to acheave:

i want to be able to track a pack from the moment it comes in the door to the time it leaves.

here is the trail the pack would take:

• pack enters the office and is logged onto the DB
• pack given out to the a member of staff
• submitted to quality ( once the editor has finished )

if there is a problem with the pack and it cant be done it is then sent back to our 'problem solving section' which once the problem is resolved they send it back to the member of staff that sent it too them.

also if there is a problem when quality get the pack then it can be sent back to the person who did the pack.

what i want to be able to do is track where the pack is at anyone time, who has done what on the pack ( i.e. entered it onto the DB, given it out, worked the pack, etc ) and the date they did it.

hope that makes sence

thanks for the help

best regards