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.