Get numeric value from other database instead of Join

gmoalfaro

Forums

Hi,
Can you help me with a script to obtain a value from other table, or populate a temporal array obtaing values fromo other table using a common code_type field on both tables as criteria to search value range

I have a Account Receivable, and need to obtain a percent value from other table (table B) using the client_type and age_range (lets say 90 days) from table A, so I need to search wath %value has the table B comparing  the client_type.
Example
Table A
Type : 3, age: 500 days

Table B
Type 3 - days: 30 percent: 10
Type 3 - days: 90 percent: 20
Type 3 - days: >90 percent: 50

So I need to obtain the 50 from table B, on Table A

I was reading this script, as example but have some sintaxis error
https://ideascripting.com/forum/obtaining-data-database-use-selection-c…

Thanks for help, I'm so rusty on programming (more than 15 years no programming, I used to programming on vBasic, SQL, foxbase, pascal, clipper and C++