Recent content by Redstick

Okay folks, I’ve abandoned ChatGPT and built my database myself and I’m amazed I’m only one step away from finishing, so I’m hoping somebody may be able to help. I’m sure you’ll want to tell me I could or should have done things differently, but what I’ve done so works. The situation is this...

I appreciate your comments but the point is this is an exercise to help me learn how to use Access. This not a real club, there will NEVER be two Jim's or two Susan's. Each member is identified by their own unique MemberID (Indexed No Duplicates), so there will never be a problem. In the...

I mean that I have a database that is easy to use and does what I want it to do with no errors. Remember I'm completely new to Access so may have to rethink my expectations depending on what I'm told is achievable and what isn't.

This is an exercise to help me understand Access databases. It's a way for me to keep my mind active. it isn't a real club, so there are no fees, no membership requirements and no score keeping or prize giving. I had an idea that I thought would challenge me and I started to try and learn by...

Not sure what you mean by Member Types. Obviously the club has multiple members. Each member can belong to multiple groups. Each member can undertake multiple activities and all activities will happen on different dates. When undertaking an activity, each member can have one or more activity...

Thanks for the link, but I'm not looking for a Genealogy database, that just came up in another post. What I'm looking for is based on club membership.

Thanks for the advice but VBA, SQL or any form of coding is not part of my skill set and just confuses me more than I already am.

I will accept your superior knowledge and experience. The Tables and their relationships are the way ChatGPT told me to build them. The partner is somebody who undertakes an activity with another member, they are not always family members and usually do reside at a different address. Members...

There is no ParentID used it is PartnerID which is used to identify the member's partner in the activities.

Attached is a zip file of my database

You're right there are a lot of similarities. I also have a large family tree (40k +) which is stored on Ancestry and in my Family Tree Maker files, but I must admit I've not done any research for a couple of years now. I will be posting a copy of my database on here shortly so you will be able...

The no duplicate first names comes from a previous project using excel where last names weren't used and I just carried that forward when I started my database.

This is the summary provided by ChatGPT I have not included details of the Junction Tables referred to in this summary but will do so if that is needed. Summary of Your Microsoft Access Database Your database is designed to track members, their activities, and their activity partners. The key...

Here is the outline information for you - I'll ask ChatGPT for a summary and post that next. What I’m looking for is a database for a club where the members are unique – each member has an individual First Name (no first name is duplicated) but because they may be member of a family, their Last...

I don't know if this is allowed and I'll understand if I'm asked to leave the form. Let me explain. I am looking for somebody to help me build an Access Database that has brought ChatGPT to its knees. Let me explain. I’m a 72-year-old man who is trying to keep his grey cells working. To this...