Hi

I have two tables:

tblHazards:
HazardsID
Hazard Description
Hazard Class
Risk Description

tblRisks:
RisksID
Risk Description
Hazard Class

What I am trying to achieve is to only show records in the Hazard table where the Hazard Class is the same for both tables.

I will be creating a list of Hazard Descriptions and Hazard Class as dropdowns for the Hazard Description field and want this to only accept Risk Descriptions which have the same Hazard Class.

Can't seem to get this to work.

Thanks to anyone who can advise.

Ralphie

You haven't described the relationship between Hazard and Risk, so it's hard to guess what you want.

I don't understand why you are holding Risk Description in tblHazards. If there is a relationship, it should be RisksID you hold.