This may be the same problem as the "left outer join" thread below and i apologise in advance.
I have two tables : Costings and Purchase names.
Costings has the following fields:- Value, Supplier code.
Purchase names has the following fields: Supplier code, supplier name.
I have linked the two tables together.
The problem I have is that the supplier code can be blank in costings due to adjustments and the report doesnt print it out because it cant find a supplier name in the Purchase names table.
Any ideas as to how to show the entries with blanks codes?
(I have read the previous thread and think the answers might related).
Thanks in advance,
SimonIn your report go to DATABASE Menu -> VISUAL LINKING EXPERT
select link between yr 2 table and then click on LINK OPTIONS button and if your Cost Table is left hand side then give Left Outer Join and if it is right hand side then Give Right Outer join...|||hi jmendpara,
Will give it ago, thanks for the advice,
Simon|||thanks that worked:)
No comments:
Post a Comment