All things TrackVia!
Read, write, comment.
Product Question
Hello,
I've been using the parent lookup relational field, but I'm not completely satisfied with the results.
This is what I've been doing so far:
I have a parent database containing tools' descriptions and specs, for example:
FAMILY SPECS
Shackles 1/4 Ton
Shackles 1/2 Ton
Sling Savers 12 1/2 Ton
Eye Bolts M30
Eye Bolts M16
... and so on
In the child database I have a link to parent record field (called ITEM1). This field is linked to the previous parent database using the field "FAMILY".
Then I have a calculated short answer with the following formula: parentlookup("ITEM1", "SPECS"). Here I'll get the specs according with the order that I follow when choosing the families. For example if I chose the first line I'll get 1/4 Ton, if I chose the second line I'll get 1/2 Ton.
Is there anyway to get a dropdown list showing all the specs for the same family? I mean, every time I choose Shackles (don't matter if it is the 1st or the 2nd row) I would be able to see both 1/4 Ton and 1/2 Ton.
Thank you in advance.
Comments
Hi Carolina,
It sounds like the best option would be to create a concatenated field in the parent database that combines family and specs. For example, it would have options such as "Shackles - 1/4 Ton" and Shackles - 1/2 Ton." This should succeed in giving you a field where all of the values are unique. Then you'd use this new field as the link.
The formula to create the concatenated field is pretty simple - for example, if you want to include a dash in between the values as I've done above, the formula would be: family & " - " & specs.
Please let us know if this works for you. Thanks for being a TrackVia customer!
Chris
TrackVia Support