Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
10 years ago

How to create a relationship between two connected dataset tables?

Hi, I've got two tables using connected datasets and each one is using a refresh key as the key value.  The values used in the refresh key for one table are also present in the other table, so I...
Formulas and functions
Relationships
Tables and fields
MCFNeil's avatar
MCFNeil
Qrew Captain
9 years ago
Part of the reason you can't use formula's is because you'd have to lock the other data that is used in the formula, and it can't be dynamic.

As it is now if you use a key field, and then change that key field value, it will mess up all the relationships.

There are always some work arounds depending on your situation. (either script, a sync table, or pre-creating records)