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...