-
Linking Problem??
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 :confused: