Auto create a table relationship
Hi 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 c...
Forum Discussion
No problem
Make the Key field of your FX rates table be the key field.
Make a new field on the data table called [Date mirror for Relationship]. The formula will just be [Date]
Make a relationship between the two tables based on that relationship.
Look up the FX rate.
The reason for creating that extra mirror formula field is so that you can still conveniently enter dates into your data table and still get to use the calendar picker
Make the Key field of your FX rates table be the key field.
Make a new field on the data table called [Date mirror for Relationship]. The formula will just be [Date]
Make a relationship between the two tables based on that relationship.
Look up the FX rate.
The reason for creating that extra mirror formula field is so that you can still conveniently enter dates into your data table and still get to use the calendar picker
