Check box query and data

[lespaul]

Hello! I have a table that stores an indentifier and a code:

JurNum SpecialCode
102 AM (mornings only)
102 HI (hearing impaired)
104 PM (afternoons only)
104 PD (physically disabled)

I have a form that has the following DB check boxes:
Mornings only
Afternoons only
Physically Disabled
Hearing Impaired

So if the juror is listed in the JurSpec table, then find the codes and check the applicable boxes. And if a box is checked, update the database with the correct combination of jurnum and specialcode.

Is this just wishful thinking? Can I do this or do I need to have the database set up more like:

Jurnum AM PM PD HI
102 Y Y
104 Y Y

Any suggestions will help! Thanks!
Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned

 

[Elkari]

If all you have in your table are the fields JurNum and SpecialCode, how do you store multiple special codes? It seems that this field needs to be at least of lenght 8 to handle a juror that would have all the boxes checked. I'm assuming if both AM and PM are checked, then the juror is available the entire day.

I would go with your second table layout. It would be easier to adjust this in the event of added special codes.


P.S. Great tag line!!!

 

[lespaul]

If they have multiple codes then there are multiple entries in the table, but I'm leaning towards the second layout as well (for that reason and ease of implementing the database check boxes).

Thanks for the response!

ps - this is from a shirt that I have - although only 1% of the people who see it get it! you can find it at ThinkGeek.com

in checking the web address I found another GOOD one:

There are 10 types of people in the world - Those that understand binary and those that don't! Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned