Forum Discussion

swebster's avatar
swebster
Frequent Visitor
8 years ago

Lookup table with no relationship

I have 2 tables, table A has date and cost, table B has date and escalation rate. There are no related id's between teh 2 tables. I want to pull an escalation rate from table B into a column in table A based on matching the date field in table A and B. Then i can multiply the table A cost by the escalation rate and get the current value.

 

I can't figure it out.

No RepliesBe the first to reply