Hi Brian,
>Can you tell us what the type of the key field of the master table, and the field you'd like to use as the reference?
The Master table is using a "composite" field type which was generated by combining three text fields together. The reference field is the same three text fields as the master key, but combined with a formula rather than the system 'refresh key'.
>You should not necessarily need to make a formula for your reference field.
Can you expand on why I should not need to use a formula? I am trying to associate two pre-existing datasets in a one-to-many fashion. The values that make up the refresh key are unique on the master table when combined together and these same values are also present in the reference table, so I would think that I should be able to combine these values together on the reference table manually to match the format of he unique ones on the master table and then associate them together.
