Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

membership phone list and activity attendance records

Posted on 2004-08-09
10
Medium Priority
?
204 Views
Last Modified: 2012-05-05

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

0
Comment
Question by:mof1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
10 Comments
 
LVL 12

Expert Comment

by:Sayedaziz
ID: 11750964
Create a form bound to Query ( tblfamilies + tblpeople linked on familiyid) and collect all master data. This will serve the purpose of presenting meaningful phonelist. However the tblpeople fields may preferably be added to tblfamilies.

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.

0
 

Author Comment

by:mof1
ID: 11769674
Thanks, but how do I get all the names side by side in a phone list report when all the prople have separate records?

0
 
LVL 12

Expert Comment

by:Sayedaziz
ID: 11769798
u can create cross tab query to display appropriate format
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 

Author Comment

by:mof1
ID: 11779278
I tried that but all I get are numbers.
How do I get the names side by side, please?

Cheers
0
 
LVL 12

Expert Comment

by:Sayedaziz
ID: 11780697
can u give us ur deired format for report doesn't u mean as follows :


Members            Address                 Phone
----------            -----------               --------

A                       AAAAAA                  11111
B                       BBBBBBB                  22222



 
0
 

Author Comment

by:mof1
ID: 11780827
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

0
 
LVL 12

Expert Comment

by:Sayedaziz
ID: 11780861
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

0
 
LVL 12

Accepted Solution

by:
Sayedaziz earned 2000 total points
ID: 11780902
For this u need to create Query say phonelistquery as follows :

              Query Structure
              ------------------
tblfamilies                         tblpeople
-----------                         -----------
familyid     ---------->        familyid
                 join field

other fields                       other fields


and use this query as a recordsource of ur report as i explained in my previous post.
0

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question