I am new to QlickView. I have two tables of different database. Both the table have two common columns.
First Table have :
ItemCode, BatchNumber, TotalPrice
Second Table have:
ItemCode, BatchNumber, Cost
I want a result in Table Box :
ItemCode, BatchNumber, TotalPrice, Cost
I am able to fetch the Cost for few rows, rest of the rows i am getting NULL value even Cost price is available for that batch.
Thanks for your reply. Please help how can i remove synthetic key so that i can get correct result. I am new to QlickView and not aware about it. After removing it would i able to link both the tables of different database as explained.
Here's the catch:
In your registry table, Batch is text format.
In stock table , Batch is numeric.
When QV creates association, it is not able to link these two columns with different formats together.
Try this script after you have loaded your stock table.
load text(Code)as Code, Batch ,Cost
drop table "HMS_STOCKGRNITEMS(NOLOCK)";
Thanks and regards,
Thank you Very Much Arthur Fong,
This script is not working, may i convert the batch to VARCHAR in SQL statement using Convert() function like:-
SELECT Distinct GI.ITEMDR "Code",