H
Hong
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.
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.