One of my friends has turned to me for help with his database, and I haven't done anything with databases in months and have no clue.
Basically, he's making a database for a pitch and putt and wants to have a field that shows the amount of games each person has played. But he wants the field to gather the information from a table showing the amount of transactions. And he wants to do it for each customer.
Sorry, I forgot to add. He wants to add a field into the customer table saying how many times they've played, and he wants to use the data from the transaction table. He wants to do it via a means of displaying how many transactions have had each customer ID.
I don't think I could have explained this any worse if I'd tried.
Thanks for any help offered.
Basically, he's making a database for a pitch and putt and wants to have a field that shows the amount of games each person has played. But he wants the field to gather the information from a table showing the amount of transactions. And he wants to do it for each customer.
Sorry, I forgot to add. He wants to add a field into the customer table saying how many times they've played, and he wants to use the data from the transaction table. He wants to do it via a means of displaying how many transactions have had each customer ID.
I don't think I could have explained this any worse if I'd tried.
Thanks for any help offered.
Last edited:
