Relationships - Parent, child and proxies
Def a noob question, but I've tried everything! I have Registration Table:
UUID [key], alphanumeric code means nothing
Name
Telephone number
Transfers table: We get a list each month...
Forum Discussion
Hi Rory, to relate the records automatically, you do need to have a unique value you can set as the key for the registrations table. However, when you say you need the transfers to appear on the registration table, is it okay to click to view an individual registration and then list all transfers whose phone numbers match? Or do you need to see that information in a report of registrations?
If you don't need to see the transfers in a report of registrations, then you may not need to use a relationship here. Instead, you can add a report link field to your registrations table to display the transfers, without actually relating the records.
To do so, edit the field properties of the report link and set it up so it reads:
Match the values in this field from this table:
Phone number
To the values in the field:
App - <name of your app>
Field - Transfers: Phone number
Then, when you add the report link field to your registrations form, edit the properties of the form element and select "Display the related transfers directly on the form".
While a report link field is automatically generated when you create a relationship, many builders don't realize that you don't need to have a relationship in order to use a report link field. You can use them to match records between un-related tables as well.
------------------------------
Brian Cafferelli
------------------------------
If you don't need to see the transfers in a report of registrations, then you may not need to use a relationship here. Instead, you can add a report link field to your registrations table to display the transfers, without actually relating the records.
To do so, edit the field properties of the report link and set it up so it reads:
Match the values in this field from this table:
Phone number
To the values in the field:
App - <name of your app>
Field - Transfers: Phone number
Then, when you add the report link field to your registrations form, edit the properties of the form element and select "Display the related transfers directly on the form".
While a report link field is automatically generated when you create a relationship, many builders don't realize that you don't need to have a relationship in order to use a report link field. You can use them to match records between un-related tables as well.
------------------------------
Brian Cafferelli
------------------------------
