I'm trying to build a club database with the following features and have had problems. I apologize for the length but hope someone can help.
1. A members table record shall include various personal data for each member (such as sex, membership category, date of birth, date joined, personal cell phone number, work phone number, etc).
2. A separate addresses table shall be provided since there may be more than one member in a given household. Also, some members may have two addresses (a primary and a secondary address), so that one may be used for summer and another for winter, for example. Each address record should include a name line for the address label (such as Mr & Mrs John Doe), two address lines, city, state, zip, country and home phone number.
3. An Enter/Revise form shall include both member and address data. The primary address shows up first. The Access-provided binocular icon will be used to search on any field. The form shall show the number of members in the currently displayed member’s household, and shall include a button for going to the next member of the same household (if more than one). [My idea here is to include in each member’s record the ID of the next household member, and for the last member this ID is that of the first household member.] The form should also allow entry of a new member in the same household. Entry of a new member in a new household is done by clicking on the >* button at the bottom of the Access-provided form.
4. A button shall be provided for switching to the secondary address (which most of the time is blank). If data is entered in the secondary address fields, a new address record shall be created in the address table that is linked to the member. A second click on this button shall return display of the primary address. The form shall clearly indicate which address is being displayed (primary or secondary). It shall be possible to delete the secondary address (and the associated record in the address table).
5. The Enter/Revise form shall allow deletion of the currently displayed member (and associated record in the members table). If the displayed member is the only member of his/her household, the associated address record(s) shall also be automatically deleted.
I hope I am not asking too much, and really hope someone is willing to help. Thank you very much.
1. A members table record shall include various personal data for each member (such as sex, membership category, date of birth, date joined, personal cell phone number, work phone number, etc).
2. A separate addresses table shall be provided since there may be more than one member in a given household. Also, some members may have two addresses (a primary and a secondary address), so that one may be used for summer and another for winter, for example. Each address record should include a name line for the address label (such as Mr & Mrs John Doe), two address lines, city, state, zip, country and home phone number.
3. An Enter/Revise form shall include both member and address data. The primary address shows up first. The Access-provided binocular icon will be used to search on any field. The form shall show the number of members in the currently displayed member’s household, and shall include a button for going to the next member of the same household (if more than one). [My idea here is to include in each member’s record the ID of the next household member, and for the last member this ID is that of the first household member.] The form should also allow entry of a new member in the same household. Entry of a new member in a new household is done by clicking on the >* button at the bottom of the Access-provided form.
4. A button shall be provided for switching to the secondary address (which most of the time is blank). If data is entered in the secondary address fields, a new address record shall be created in the address table that is linked to the member. A second click on this button shall return display of the primary address. The form shall clearly indicate which address is being displayed (primary or secondary). It shall be possible to delete the secondary address (and the associated record in the address table).
5. The Enter/Revise form shall allow deletion of the currently displayed member (and associated record in the members table). If the displayed member is the only member of his/her household, the associated address record(s) shall also be automatically deleted.
I hope I am not asking too much, and really hope someone is willing to help. Thank you very much.
![[wavey]](/data/assets/smilies/wavey.gif "[wavey] [wavey]")
