I have two questions about setting up MS Access forms: 1) Currently, I have a form to enter the volunteer id, shift start time and shift stop time, but the client doesn't want to have to look up the id in a report. Is there a way to create a selection list from the volunteer's names? What other options are there? 2) On the "add/edit a volunteer" form, I'd like to be able to choose tasks from a selection list. The tasks table has id and name. The "tasks of volunteers" join table has volunteer id and task id. How do I set this up? I can't seem to get the right combination of configurations. [more inside]
posted by philomathoholic on Aug 5, 2009 - 7 answers

Can you recommend a forms based database like Filemaker, MS Access, or OoO Base, but lightweight? [more inside]
posted by Ookseer on Jul 21, 2008 - 3 answers

What are best practices for storing arbitrary form data? More inside... [more inside]
posted by zackola on Jan 24, 2008 - 6 answers

Help me properly set up a very small relational db. This is a teensy bit over my head, so mainly I want to establish that I'm not going terribly wrong before I get too far into this. [more inside]
posted by desjardins on Jun 6, 2007 - 5 answers

What kind of software can I use to keep track of information on each client and/or project that I'm working on? [more inside]
posted by iguanapolitico on Apr 24, 2007 - 7 answers