tabular form that groups fields into combo boxes

A

Amanda

I have a Membership table with a unique ID fro each membership. Memberships
are applied to families, so there are multiple people associated with a
single membership.

I have a Membership query that returns the unique membership ID, and the
name of each family member in the membership:

Example:
Member ID Name
1 John Smith
1 Jane Smith
2 Susan Doe

I want to create a tabular form from the Membership Query that will create a
row for each membership ID, and a dropdown box with the names of the family
members associated with that Member ID.

How do I do that?

Thanks, Amanda
 
A

Amanda

There is a Household Table that holds info related to a single address- has a
unique Household ID field.

There is a People table that holds info related to that person, tied to the
Household table with Household ID. As we assign Member Numbers to people
(persons in the same household that have a family membership have individual
Member Numbers), there is a Member Number field.

There is a Membership table with a unique Member ID and a related Household
ID. This also has fields that are unique to the membership, such as
"membership type" (family, individual, or student).

The form will be designed to manage memberships. So ultimately, the form
will probably also have a subform or popup form for Membership entries that
exist in the Journal table (each person has a journal that tracks dates and
types of interactions)- this will be for join date, renewal dates, etc.

Right now I'm experimenting with creating the form based on the table, not a
query, and then setting data properties for the objects based on queries.

- Amanda
 
S

strive4peace

Hi Amanda,

firstly, do not use NAME as a fieldname, it is a *reserved word*

Problem names and reserved words in Access, by Allen Browne
http://www.allenbrowne.com/AppIssueBadWord.html

~~~

"I want to create a tabular form from the Membership Query that will
create a row for each membership ID, and a dropdown box with the names
of the family members associated with that Member ID."

Sounds like you need make a main form based on the Membership table and
a subform based on the Household Table.

Member ID will be a control on each form and will be used for
LinkMasterFields and LinkChildFields. In the form you make to use as a
subform, you can set Visible=No

To learn more about setting up a main form and subforms, read Access
Basics in my siggy

~~~

If you are really wanting to limit choices in a combobox on, for
instance, a form based on a different table, let us know and we will
tell you how to do that.


Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
:) have an awesome day :)
*
 

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

One main form to update several tables? 3
Can "like" function be used with combo box? 3
tie multiple values from second table to first table 1
User Interface to select Individual or Company Donors 3
Counting multiple memberships 1
Searching with a combo box (repost/rewrite) 2
Renewing member database design question. 7
Form based on two queries 11

Top