Lookup in a query with unrelated table??

[bsnapool]

Hi,

Is it possible to create a lookup in a query against a table which has not relationship but has a match?

E.g. iif(spec(in query)=Spec (match table) then bring back cost in (match table)

Hope this makes sense?

Thanks

 

[neileg]

Join the two datasets in your query on the relevant field. It doesn't matter if there's no relationship in your relationship diagram, you can create it in the query.