0

"This database needs to track how often a member has used the golf course, and how many guests any and each member has brought to the club."

^That is part of our case problem that I can't figure out how to do it. I'm done recording each member or guest who goes to the club, but I don't have an idea how will i track the member uses golf course and how many guests s/he invited.

Help me please :( I really need this. It's for our defense tomorrow. It's okay if you don't give me codes, just tell me what to do. That'll will help me a lot. Please

Edited by thirteen_xx: clarification

3
Contributors
4
Replies
33
Views
3 Years
Discussion Span
Last Post by om314
0

Whare does the table already contain? Just add two more columns -- one to count the number of times the member uses the golf course and another to count the number of guests. When a member comes to the golf course look up is row in the table and increment the two columns.

0

the table contains information about the member such as: no (PK), name, mail, contact info, membership type. same with the guest.

what do you mean by "look up is row in the table and increment the two columns."?

0

this is how my records look like now. Still have the same problem.

Attachments untitled.JPG 17.86 KB
1

I would do it like this:
Keep your original table.
New table
visits
- visit_id (autoincrement int)
- no (FK) <--- refers to your original table
- visit_date (datetime)
- guest_count (smallint)

Then, for each visit, add a row to visits. You can then query visits for totals based on date range, etc.

Votes + Comments
good suggestion
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.