relation between three tables for relationships.ini

[Philipp Wenzel]

Hi.. again ,
i have three tables:
nation
-nation_id(primary)
-nation_name
-etc pp

risiko
-nation_id(prim)
-risiko_terror boolean (1-yes,2-no)
-risiko_duerre boolean (1-yes,2-no)
-etc pp

duerre
-duerre_id(prim)
-nation_id(foreign)
-etc pp

i want to display a nav tab (for every risc factor) in the "risiko" section (via relationships.ini) but only for the risiko table entries which have the value 1.
im not able to figure out the right sql query
can anybody help me?

so long,
phil

[shannah]

Can you explain exactly what the relationship is. I see 3 tables. What is the source table, and what is the destination table.

[Philipp Wenzel]

Hi Steve,
I want to insert into the "duerre" table.
the link to the insertform is generated by an entry in the relationsships.ini (headtable: "risiko").
but it should by only visible when the "risiko_duerre" value is set to yes.

so the source tables are nation and risiko (risiko is related to nation) and the destination table is duerre (which is related to risiko and nation).

hope i could unravel the mistery
Phil