ContributionsMost RecentMost LikesSolutionsRe: Auto create a table relationshipYep, I did. :-) Thanks again.Re: Auto create a table relationshipThank you - that works!Auto create a table relationshipHi Quickbase users, I have a table with a Date field and a Numeric field which can be either dollars or euros. One more field specifies the currency (i.e. "USD" or "EUR"). Now I am trying to create a new calculated Numeric field which would have everything in EUR. To achieve this I created a second table with daily USD-EUR FX rates (it has date and rate fields). What I am trying to achieve is to automatically retrieve the exchange rate for a relevant date from the FX table and multiply it by the Numeric field in the first table. I tried to create a table to table relationship but this way you need to link these tables manually. I am looking to automatically link them using the date field as reference. Hope it makes sense. Thank you, Dmitry