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 #5582 is a reply to message #5578]

Sat, 28 May 2016 05:09

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

Senior Member

I notice that your link table contains two rdcaccount_id columns, one for each of the parent tables. Unless the rdcaccount_id column is part of the primary key in those parent tables it is not necessary to define them as foreign keys in the link table. The way that a POPUP2 works is that you first identify a single row on the parent/outer table, then use the primary key as the WHERE clause when reading from the child/inner table. If you are reading entries from the child table which do not belong to the parent then there is something wrong.

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: Sun Nov 24 21:47:17 EST 2024

Total time taken to generate the page: 0.01534 seconds