Can you out perform ChatGTP?

[The_Doc_Man]

each of the members activities can have multiple partners

From your description including but not limited to that statement, I think you need to look up what are called JUNCTION TABLES.

It would assume that a member's partner is ALSO a member. Your junction table will include not less than one slot for the member's ID, one slot for the partner's ID, one slot for an activity code, and MAYBE (if this applies) a slot to make the partnership unique IF the member has more than one partner for a given activity. If you have multi-partner teams (i.e. >2 members) this still works if you have team ID (for example).

 

[GaP42]

I have a different view on the relationships: as stated by Redstick it is not a genealogy database, however associations between members need to be supported to allow recognition of partnerships - meaning generally teams. Family associations between members (may) also need to be recognised. Without going into the detail, the following supports these requirements.

I know that there is no stated requirement for attendance at an event / GroupActivity. Just threw it up as there is nothing to say because you are a member of the team and the team played that a particular member participated on that occassion. A similar arrangement is used to track attendance at scheduled meetings.

 

[LarryE]

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’ve got a Members Form that contains 3 functioning sub forms, but I’m having difficulties with the fourth one because it also contains its own sub form and I’m having trouble linking the two.

The fourth sub form records the member’s Activities – (Activity Name, Activity Date & member age at Activity Date) – Now all of that works in the Members Form but within that sub form I want to add another sub form to record the member’s Partner details. All I need to record are the Partner’s Name and their age at the activity date. I have built a sub form to do that but the problem I’m having is linking it to the member sub form so that each of the members activities can have multiple partners. I have tried several Master/Child links, but nothing works. The sub forms are built on queries from the appropriate Junction Tables.

If you need any images of anything, let me know what you want to see and I’ll post them

Please take a screenshot of your relationship window and copy it into a post so we can see the design.

 

[gemma-the-husky]

If you cant link a form and a subform by using the wizard, you might be able to manually set the linking fields.

Alternatively, in the master form, you can use the current event to set a public global variable to the value of the linking field. Then change the sub form to use the public variable in the query that drives the subform.

So in the master form, in the current event you set the public variable, and then requery the subform, all in code.

 

[CarlettoFed]

I took the liberty of creating an example, to work with it extract the files and open the MembersManagement.accdb file