Structure of DB is:

Org_Year(Table)

• ID
• Org_Name_ID
• Org_Year

Ft(Table)

• ID
• Org_Year_ID
• Count

Org_Name(Table)

• ID
• Org_Name

I've created a form to input data into Ft. Form has reference to Org_name. I should be able to choose between different org first. Afterwards i want to choose which year to enter data into Ft for. I only want to be presented with a list of Years according to the entries in the Org_Year table, where org matches my selection in the dropdown above.

The query to populate the select box (Org_year_Box) is:

SELECT Org_Year
FROM Org_Year
WHERE Org_Name_ID=Organisation_Name_ID.value;

I't doesn't return the Years for the given Org_id when using the above query. But if i replace "Organisation_Name_ID.value" with the actual value ie. "2" it returns the correct years.

How to do?