Option buttons

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm new to Access, obviously, and I'm building a DB for our PTA. I'm trying
to check all volunteer oppourtunities that a member is interested in for each
record. It needs to be able to facilitate multiple choices in the form, seen
at a glance on the form, and be flexible enough to change daily if
neccessary. I've gotten everythig else to work but this.
 
Do not try to do this with lots of options in one table.

Instead, you need a relational structure that needs at least 3 tables:
- Volunteer (one record for each person);
- Interest (one record for each type of interest);
- VolunteerInterest (one record for each interest of each volunteer.)

More details:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open another form if field checked in one form 1
Command Button to Sort and Filter by Selection 3
building form @ runtime vs. hiding existing controls 6
Building new machines 4
Build Option is Grayed Out 2
editing fields on forms based on more than 1 table/query. 2
Setting RecordSource off of Radio Buttons 3
Stuck on form design and appropiate control to use, Need Help Plea 2

Back
Top