I have an enquiry record which records the receiving and quoting of an enquiry received from our customer. In this we have a subform which has a look up field which records which supplier we have usedand the value of their quotation.

We have another form which for Suppliers. In this Supplier form, I want to have a subform that displays the previous 5 enquiries where we have used this supplier. It will display fields Our Ref.:, Customer, Date Rcd, Drop Down, Value (from Supplier subform).

Any help much appreciated.

Thanks,