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 relation****p 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.
