Combo Boxes in Subform

[geet72]

I am working on a insurance database. I have 4 tables
1. policy_details table with Payment Type such as Annual, Qtr, Semi Annual etc.
2. policy Payment table with details about payment such as amount, date of payment etc
3. policy Categories table which defines the types 1- Annual, 3-Atr, 5 for Semiannual.
4. policy Categories type with Qtrs information. Payment type No - 3, Qtr - Q1, Payment Type No - 3, Qtr - Q2 etc

Relationships: Policy details - policy payment table - One to Many on Policy no
Policy payment - Policy categories - One to Many on Policy payment type
policy categories - policy categories qtr - One to Many on Policy payment type

I have created form and sub form. The sub form is from the policy payment table. I have two combo boxes in subform. Policy type no - Annual, Qtr, Semi annual etc. When Qtr is selected, the second combo box should show Q1, Q2, Q3 and Q4. This works fine.

However, I am not able to select Q1, Q3 or Q4. Even if I click Q2 or subform, only Q1 is always selected.

I think this is a problem with relationships and I do not know how to fix it. Can anyone help

Regards

 

[CEH]

The post gets rather confusing... But first, it sounds like you have duplicate fields in your tables. After you fix this and "normalize" your DB then do a search on "Cascading combo" Basically what it will come down to is the row source of your second combo box will be a query that contains the value of the first combo box.