Already create link key for 2 Table but two table not link ?

[paulyeo11]

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

[prma7799]

You can use apply map here .

What is relation between Cust_id and cust_id_ar ?

[paulyeo11]

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

[prma7799]

Please let us know which filed have common in AR_TABLE and ARSummary.

[paulyeo11]

one 3 field in common for AP table ARSummary table. See below :-

[prma7799 · Accepted solution]

Just rename SOURCE and Cust_ID from ARS_SUMMARY table and try ..

[paulyeo11]

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