Relevant data not cascading through

[paulcraigdainty]

As part of my data structure I have a Fault table, Transaction table & Resolver table. The Resolver's are dependant on the Transaction that are selected in the fault table. What I am after (and it's not happening) is when selecting a Transaction in the Fault table the only resolver that is available to the user is the one related to the choosen Transaction.

At the moment after selecting a Transaction all Resolver's from the Resolver table are available. When creating my Fault table I selecting the Resolver field as a Lookup and choose the Transaction table and the Resolver field.

 

[neileg]

Are you working in the tables directly, perhaps using sub data tables? If so, I don't think you can do this.

If you were working in a form, which is where you have all of Access's tools available, this is relatively easy.