Radicore Forum: Transaction Patterns » PopUp

Home » RADICORE development » Transaction Patterns » PopUp - Link1 table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: PopUp - Link1 table [message #7424 is a reply to message #7423]

Sun, 22 March 2020 05:19

AJM
Messages: 2371
Registered: April 2006
Location: Surrey, UK

Senior Member

You need to start by identifying if you have the right database structure. If you have a collection of teams, and a collection of players, then in order to identify which players can be members of which teams you have a classic many-to-many situation where a team can have many players and a player can belong to many teams. No database can support a many-to-many relationship, so you have to implement a pair of one-to-many relationships with a "link" or "intersection" table in the middle. So you would end up with a structure such as this:

TEAM => MEMBER <= PLAYER

where TEAM => MEMBER is one-to-many and PLAYER => MEMBER is one-to-many.

This then allows you to have such tasks as "Show me all the PLAYERS who are members of TEAM x" and "show me all the TEAMS to which PLAYER x is a member"

This is precisely the situation for which I developed the ADD3 pattern?

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		PopUp - Link1 table By: htManager on Mon, 23 May 2016 04:44
		Re: PopUp - Link1 table By: AJM on Mon, 23 May 2016 05:59
		Re: PopUp - Link1 table By: htManager on Tue, 24 May 2016 10:37
		Re: PopUp - Link1 table By: AJM on Wed, 25 May 2016 04:39
		Re: PopUp - Link1 table By: htManager on Wed, 25 May 2016 06:21
		Re: PopUp - Link1 table By: AJM on Wed, 25 May 2016 07:28
		Re: PopUp - Link1 table By: htManager on Wed, 25 May 2016 09:57
		Re: PopUp - Link1 table By: AJM on Wed, 25 May 2016 10:12
		Re: PopUp - Link1 table By: htManager on Thu, 26 May 2016 12:58
		Re: PopUp - Link1 table By: AJM on Thu, 26 May 2016 14:48
		Re: PopUp - Link1 table By: htManager on Fri, 27 May 2016 03:09
		Re: PopUp - Link1 table By: AJM on Fri, 27 May 2016 05:41
		Re: PopUp - Link1 table By: htManager on Fri, 27 May 2016 10:00
		Re: PopUp - Link1 table By: AJM on Sat, 28 May 2016 05:09
		Re: PopUp - Link1 table By: htManager on Tue, 31 May 2016 05:00
		Re: PopUp - Link1 table By: AJM on Wed, 01 June 2016 05:18
		Re: PopUp - Link1 table By: htManager on Sun, 15 March 2020 05:59
		Re: PopUp - Link1 table By: AJM on Sun, 15 March 2020 12:51
		Re: PopUp - Link1 table By: htManager on Sun, 15 March 2020 15:16
		Re: PopUp - Link1 table By: AJM on Mon, 16 March 2020 13:02
		Re: PopUp - Link1 table By: htManager on Tue, 17 March 2020 07:45
		Re: PopUp - Link1 table By: AJM on Wed, 18 March 2020 06:28
		Re: PopUp - Link1 table By: htManager on Wed, 18 March 2020 12:23
		Re: PopUp - Link1 table By: AJM on Thu, 19 March 2020 05:23
		Re: PopUp - Link1 table By: htManager on Fri, 20 March 2020 08:31
		Re: PopUp - Link1 table By: AJM on Sat, 21 March 2020 07:52
		Re: PopUp - Link1 table By: htManager on Sun, 22 March 2020 04:45
		Re: PopUp - Link1 table By: AJM on Sun, 22 March 2020 05:19
		Re: PopUp - Link1 table By: htManager on Sun, 22 March 2020 09:41
		Re: PopUp - Link1 table By: AJM on Mon, 23 March 2020 06:47
		Re: PopUp - Link1 table By: htManager on Mon, 23 March 2020 16:57
		Re: PopUp - Link1 table By: htManager on Wed, 12 August 2020 06:54
		Re: PopUp - Link1 table By: AJM on Sat, 15 August 2020 04:38

Previous Topic:	Filepicker - choose Null button
Next Topic:	List view (List3)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 28 12:23:12 EST 2024

Total time taken to generate the page: 0.09148 seconds