I am currently linking about a gazzillion tables and so far so good I am having difficulties linking my last table (always the way!) and wondered if there was a way of sorting out this problem:

The two tables are:

PN_WORK_ORDERS &
PN_QUOTES

There is only ever one work order per record, but there may be many quotes per work order.

I require information relating only to data with the highest quote number e.g.

if there were three quotes for a given work order I would only require information relating to quote number three (the most recent).

The number of records I would expect to see for example is 60,000, instead I am getting 70,000 because of the extra quotes.

I am at a complete standstill as to how to resolve my problem and would appreciate any help.

Thanks