Radicore Forum
Fast Uncompromising Discussions. FUDforum will get your users talking.

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.)
Re: How to provide choices for two compound foreign keys in a form? [message #4938 is a reply to message #4856] Wed, 26 August 2015 22:14 Go to previous messageGo to previous message
rafs is currently offline  rafs
Messages: 69
Registered: May 2015
Member
families --< families_variants >-- variants
family_name  family_name           variant_name
...          variant_name          ...

families_variants --< lines
                      line_id
                      family_name
                      variant_name


In the new 'lines' form, both popups now work. popup1 for "Family Name" field works, but popup2 families_variants (which does a popup1 for families first) then correctly gets the child value, and returns. It overwrites whatever was chosen previously in the "Family Name" field.

When "Family Name" (parent) is selected beforehand, then I want the "Variant Name" (popup2) to skip the launch of the popup1 (to choose the parent (family) again. This is the case #1 you describe here:
http://www.tonymarston.net/php-mysql/infrastructure-faq.html #faq79

Why doesn't the popup2 see that the parent has already been selected?

Thanks.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Compound foreign keys in linking tables
Next Topic: ERROR: 22P02: invalid input syntax for integer
Goto Forum:
  


Current Time: Sun May 12 16:06:28 EDT 2024

Total time taken to generate the page: 0.00933 seconds