I created a query from a table with 3 fields:
CartridgeID (KF)
Brand
Unit Price
I want to be able to create a query where it is possible to have a dropdown list of the CartridgeID's as the first field and then for the correct brand and UnitPrice to be displayed depending on what CartridgeID...