mof1
asked on
membership phone list and activity attendance records
I am building a membership database for an organisation which has family members in it. The things we need are an address list and a roll that records who attends each activity. This is an ongoing exercise.
I have a table called "tblFamilies" with the primary field called "familyid". It also has fields for addresses, phone etc for the households.
I have another table called "tblPeople" with fields called "peopleid", "familyname" (drawn from "familyid" above), "pfn" (firstname).
I want to create the phone list so that it shows the surname, man's name, woman's name and children's names alongside each other and the home address.
I want attendances to be easily recorded. Preferably so that all individual's names appear in a column with the activity alongside. Attendance needs to be tracked so we can follow trends.
How do I do this so that we can can have a well presented phone list and an efficient means of recording individual attendances at activities?
Thanks
mof
ASKER
Thanks, but how do I get all the names side by side in a phone list report when all the prople have separate records?
u can create cross tab query to display appropriate format
ASKER
I tried that but all I get are numbers.
How do I get the names side by side, please?
Cheers
How do I get the names side by side, please?
Cheers
can u give us ur deired format for report doesn't u mean as follows :
Members Address Phone
---------- ----------- --------
A AAAAAA 11111
B BBBBBBB 22222
Members Address Phone
---------- ----------- --------
A AAAAAA 11111
B BBBBBBB 22222
ASKER
here goes...
In tblfamilies I have fields for familyid, familyname, address etc.
In tblpeople I have fields for familyid, pfn, and familyorder.
I want the report to display
"familyname" then alongside that the "address" then alongside that the "pfn" of every bodyy in that family.
Jones, 123 Main St, Bill & Jane, Bob, Sam & Ben
Smith, 4 High St, Harry & Sue, Karen, Helen & Mary
Cheers
In tblfamilies I have fields for familyid, familyname, address etc.
In tblpeople I have fields for familyid, pfn, and familyorder.
I want the report to display
"familyname" then alongside that the "address" then alongside that the "pfn" of every bodyy in that family.
Jones, 123 Main St, Bill & Jane, Bob, Sam & Ben
Smith, 4 High St, Harry & Sue, Karen, Helen & Mary
Cheers
its so simple
open report in designview and in detail section place all textboxes required.
in property sheet of report select from drop down the name of table/query as recordsource.
and for textboxes on report select from dropdown the name of table/queryfield like
text1 ( control source membername)
text2 ( control source address)
and so on ...
if u feel any problem just try to run Report wizard
open report in designview and in detail section place all textboxes required.
in property sheet of report select from drop down the name of table/query as recordsource.
and for textboxes on report select from dropdown the name of table/queryfield like
text1 ( control source membername)
text2 ( control source address)
and so on ...
if u feel any problem just try to run Report wizard
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Create another main form bound to Query ( tblfamilies + tbl people ) but all fields locked so user wouldn't be able to change the master data from this form.
place subform bound to activities related table with additional unique fields for presenting data relating to activities attended by the members.