Radicore Forum: Transaction Patterns » Output 3

Home » RADICORE development » Transaction Patterns » Output 3 - _cm_output_multi()

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

Re: Output 3 - _cm_output_multi() [message #7651 is a reply to message #7650]

Fri, 03 September 2021 04:48

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

Senior Member

If the parent table has a compound primary key then any child table must have a compound foreign key where every column within the foreign key is matched to the corresponding column in the primary key.

In your above example the columns A1_id, A2_id, A3_id in the child table would be the foreign key with U_id being part of the primary key. In this case you should not have to take any action as the components of the foreign key have exactly the same names as the components of the primary key, so no swapping of column names is necessary.

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

Report message to a moderator

[Message index]

		Output 3 - _cm_output_multi() By: htManager on Tue, 03 August 2021 16:14
		Re: Output 3 - _cm_output_multi() By: htManager on Wed, 04 August 2021 05:21
		Re: Output 3 - _cm_output_multi() By: AJM on Wed, 04 August 2021 05:22
		Re: Output 3 - _cm_output_multi() By: htManager on Wed, 04 August 2021 06:19
		Re: Output 3 - _cm_output_multi() By: AJM on Thu, 05 August 2021 04:57
		Re: Output 3 - _cm_output_multi() By: AJM on Thu, 05 August 2021 05:03
		Re: Output 3 - _cm_output_multi() By: htManager on Thu, 05 August 2021 11:50
		Re: Output 3 - _cm_output_multi() By: AJM on Thu, 05 August 2021 13:46
		Re: Output 3 - _cm_output_multi() By: htManager on Fri, 06 August 2021 05:06
		Re: Output 3 - _cm_output_multi() By: AJM on Sat, 07 August 2021 05:16
		Re: Output 3 - _cm_output_multi() By: htManager on Sat, 07 August 2021 05:45
		Re: Output 3 - _cm_output_multi() By: AJM on Sun, 08 August 2021 06:00
		Re: Output 3 - _cm_output_multi() By: htManager on Sun, 08 August 2021 07:31
		Re: Output 3 - _cm_output_multi() By: htManager on Mon, 09 August 2021 04:07
		Re: Output 3 - _cm_output_multi() By: AJM on Tue, 10 August 2021 04:33
		Re: Output 3 - _cm_output_multi() By: htManager on Tue, 10 August 2021 06:34
		Re: Output 3 - _cm_output_multi() By: AJM on Wed, 11 August 2021 05:04
		Re: Output 3 - _cm_output_multi() By: htManager on Wed, 11 August 2021 16:09
		Re: Output 3 - _cm_output_multi() By: AJM on Thu, 12 August 2021 05:04
		Re: Output 3 - _cm_output_multi() By: htManager on Sat, 14 August 2021 04:26
		Re: Output 3 - _cm_output_multi() By: AJM on Sat, 14 August 2021 04:56
		Re: Output 3 - _cm_output_multi() By: htManager on Tue, 17 August 2021 06:54
		Re: Output 3 - _cm_output_multi() By: htManager on Mon, 30 August 2021 09:52
		Re: Output 3 - _cm_output_multi() By: AJM on Tue, 31 August 2021 04:52
		Re: Output 3 - _cm_output_multi() By: htManager on Thu, 02 September 2021 11:34
		Re: Output 3 - _cm_output_multi() By: AJM on Fri, 03 September 2021 04:48
		Re: Output 3 - _cm_output_multi() By: htManager on Sun, 24 October 2021 05:40
		Re: Output 3 - _cm_output_multi() By: AJM on Mon, 25 October 2021 04:47
		Re: Output 3 - _cm_output_multi() By: htManager on Mon, 25 October 2021 06:36
		Re: Output 3 - _cm_output_multi() By: AJM on Tue, 26 October 2021 04:37
		Re: Output 3 - _cm_output_multi() By: htManager on Tue, 26 October 2021 06:29
		Re: Output 3 - _cm_output_multi() By: AJM on Wed, 27 October 2021 04:37

Previous Topic:	POPUP3 not working
Next Topic:	Tree structure with more than one table

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Nov 24 05:09:30 EST 2024

Total time taken to generate the page: 0.01673 seconds