Radicore Forum: Application Development » How to provide choices for two compound foreign keys in a form?

Home » RADICORE development » Application Development » How to provide choices for two compound foreign keys in a form? (I want to provide a selection mechanism such that fill two fields in a form can be chosen and populated.)

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

Re: How to provide choices for two compound foreign keys in a form? [message #4939 is a reply to message #4938]

Thu, 27 August 2015 05:47

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

Senior Member

You need to look at the code in the _cm_initialise() method of the parent entity in the POPUP2 task. If the $where string contains something that identifies an entry on that table then continue, otherwise jump to a POPUP1 task to allow the user to select an entry.

This means that when calling the POPUP2 task and you already have a value for the parent entity which you want to use then this value must be included in the $where string which is passed to the POPUP2 task.

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

Report message to a moderator

[Message index]

		How to provide choices for two compound foreign keys in a form? By: rafs on Tue, 21 July 2015 21:15
		Re: How to provide choices for two compound foreign keys in a form? By: AJM on Wed, 22 July 2015 06:30
		Re: How to provide choices for two compound foreign keys in a form? By: rafs on Wed, 22 July 2015 10:14
		Re: How to provide choices for two compound foreign keys in a form? By: AJM on Thu, 23 July 2015 07:18
		Re: How to provide choices for two compound foreign keys in a form? By: rafs on Wed, 26 August 2015 22:14
		Re: How to provide choices for two compound foreign keys in a form? By: AJM on Thu, 27 August 2015 05:47

Previous Topic:	Compound foreign keys in linking tables
Next Topic:	ERROR: 22P02: invalid input syntax for integer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Jun 17 23:56:36 EDT 2025

Total time taken to generate the page: 0.01081 seconds