Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
autonumber( @1:9T & '_' & 'TDSS' ) as ARKey_,
I have create the above script at Payment_SG and AR_SG Tab
@10:38T as [COMPANY_PAY],
I have create the above script at Payment_SG tab
left(@10:38T,25) as [company_ap],
I have create the above script at AR_SG tab
Why these 2 table still not link ? can some one advise me where i go wrong ?
Paul
You can use apply map here .
What is relation between Cust_id and cust_id_ar ?
Hi P M
Both cust_id and cust_id_ar are same , which is customer ID.
May i know how to make use of apply map for link TERMS field to AR Table ? For ApplyMap i use a lot to recode field label name . i cannot think of how applymap can be use for link TERMS to AR Table.
Pls share.
Paul
Please let us know which filed have common in AR_TABLE and ARSummary.
one 3 field in common for AP table ARSummary table. See below :-
Just rename SOURCE and Cust_ID from ARS_SUMMARY table and try ..
Hi P M
In the process of rename the field , i found i make one error on ARKey.
Now working fine,
thank you very much
Paul Yeo