Tables Structure

[mustafaelryah]

Dear All,

I have 3 tables:

1-Accounts

     1.1 AccountID

     1.2 (formula (AccountID)) as Budget_Cat..... # Calculated Column from the above one

     1.3 CompanyID

2-Buget

     2.1 Date

     2.2 Budget_Cat

     2.3 CompanyID

3.Transaction

     3.1 AccountID

     3.2 Debit

     3.3 Credit

     3.4 Date

     3.5 Company ID

I need to link  the Budget table with the Account table  (Budget_Cat, CompanyID) and Transaction table  (CompanyID, Date)

without looping or Syntactic keys

# note that the Budget_Cat is calculated field.

Regards

[mustafaelryah]

My Dear I can't get your solution,

I attached to you the code in the below link:

https://www.dropbox.com/s/2l3a7yyjtkjmybx/QV.rar?dl=0

make your changes on it  and tell me if it worked

[alex_millan · Accepted solution]

Find attached the text files with the script for each tab.

With this script, the mapping works well.

But anyway, as there's not  a single common value between the two tables (transactions and budget), it seems no association is done, although it is. Check the attached image.

Use this script and check the values for the common key.

[mustafaelryah]

Alex , really I don't know how to thank you, I solved the completed the mismatching, now it is working successfully.

Thank Mr.Alex

With Regards

Mustafa Elryah

[alex_millan]

You're welcome Mustafa! So many time I've been helped by others, I just try to return what I got before

Cheers!