How to provide choices for two compound foreign keys in a form? [message #4853] |
Tue, 21 July 2015 21:15 ![Go to next message Go to previous message](/theme/default/images/down.png) |
rafs
Messages: 69 Registered: May 2015
|
Member |
|
|
I have a list1 for families, a list1 for variants.
I have a link1 from families to variants; and a link1 from variants to families.
families --< families_variants >-- variants
famiilies_variants only has (family_name, variant_name) as PK, with each field also being a FK to the parent tables.
This part is working fine.
Now, I have a table called lines, and a line is has a compound foreign key linking it to families_variants.
So,
lines
-----
line_id
line_text
...
family_name
variant_name
The question is, when filling in the New 'line' form, how to best go about providing the user with a method to select a combination of (family_name, variant_name) from the available entries in families_variants?
It would be good to allow them to choose a family_name, and then choose the available variant_names, or (bonus) if they could choose variant_name first, then choose the available families.
|
|
|