Form design

[Guest]

Hello, I have a database design like this:
table: DefectType, field: DefectTypeID, Defecttype, only three record:
Supplier related, Process Related, Design Related.
table: Defects, filed: DefectsID, Defects, DefecttypeID.

Because there are different defects belong to different defect types.

In a form: I have three check boxes for the three defect type. and it's
working.

But I don't know how to make it related to the table defects.
I need to put three fields for defects belong to three defect type.
For example:
When I check the Supplier related, only show the defects related to the
supplier related.

Thank you so much for your help.

 

[Guest]

You could try using an optiongroup and bind this to the defects field.

Maurice