Hi
I’m working on an event planning system for trainers. Are there any ideas and hints on when it is better to use a pick list than a linked form/field (or vice versa)? Or are there any advantages/disavantages?
Merci.
-
This topic was modified 1 day, 11 hours ago by
Oliver.
Hi Oliver,
Pick Lists are great if all you want to do is copy a value into a field from a pre-defined list of values. For example, if you have a Province field in your form, you would have a list of provinces that you can select from and when you select one, the value is copied into the field. It saves you from having to type in the value over and over again.
A Link to Form field is great when you want to establish a relationship between two forms. For example, you have a Music Library form and you have a Musicians form. But you have more than just a list of musician names. They have first names, last names, birth dates, band names, music genre, and so on. You create your record in the Music Library form for a specific album and then you want to link to that album the list of musicians that played on that album. This specific case would be a good use for a Many to Many relationship because a musician can play on many different albums and those albums can have many different musicians.
Other relationships are more suited for One to Many or Join Link Types.
See the online user guide for more information on those:
https://www.tapforms.com/help-mac/5.3/en/topic/relationships
Thanks!
Brendan
Hi Brendan
Many thanks for your answer. Are the pickup lists in principle like fixed fields also queryable or usable via javascript?
-oliver
