How to select display multiple records and allow selection of just 1 for input to second table

S

Steve

Hi,

I'm using Acess 2003. I have a table of volunteers with all their personal
information and particular role. I need to provide different uniforms for
the volunteers based on their role and want to create a form for entry that
displays choices based on role. My questions (actually questions):

How do I display multiple records from the volunteer table - say all the
volunteers that start with last name Jones, and condition what displays on a
Uniform Entry form - or subform - based on the role in the volunteer table?
For example, the uniform coordinator wants to add the uniform choices for
volunteer 'A'. Volunteer A gets specific choices based on their role. My
vision, Uniform coordinator selects 'A' and the name and role display on the
uniform entry form along with only choices that apply to that role.

I've tried finding additional information about requery but have not been
successful and am not sure I understand the correct use of requerying.

The Volunteer table and Uniform table share the same Primary Key of Unique
Volunteer ID# - a auto number assigned as new volunteers are entered. I
tried building a relationship between the two tables but I must be missing
somethign as the results were not as expected. I'm trying to have redundant
fields in two tables; hence the reason for selecting individual from the
volunteers table and keeping uniform info separately allowing the linkage by
Unique ID.

I hope this makes sense. I've really tried getting this done without seeking
assistance but am now spinning my wheels and not finding the information in
what I read.

THX for any help.
 

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

Top