Hello.
I am trying to setup a query between two tables (tblAlpha and tblBeta). These tables share an IncidentIDNum.
tblAlpha can only have one record per IncidentIDNum
However, tblBeta can have up to two records per IncidentIDNum. This is because tblBeta can have an incident where the value of cboCategory can be both "Fake" and "Smuggled"
When I run my query now, I can have the IncidentIDNum repeated twice because tblBeta has both "Fake" and "Smuggled" records.
When I parse my data however, "Fake" always supercedes "Smuggled". Therefore, I would like my query to do as follows: {Wherever a tblBeta has both "Fake" and "Smuggled" linked to a single incident, only return "Fake" in the query.)
I really hope that makes sense...
Thanks!