Drop down select from a second, non-fabrik table

[jeffhoneyager]

Fabrik table / list call "document"

In the form I want to display a drop down list using the "name" field from a different component's table called "exam". I want to insert the name and record id from that list into the document table/list.

When I create a join on the document table with the exam table it puts all the fields from the exam table into the document form. The exam table has 80 fields and all I want to include is the exam.id and exam.name fields.

Any suggestions?

Thanks.

 

[troester]

Not sure what you mean:
a database join element (which should just show what you have selected as "label") or a list join (which is no drop down)?
If you have a list join: yes, this will create a new group with all columns as elements.
You can disable all elements you don't need.

 

[cheesegrits]

Sounds like you just need to create a join element, not a list join. Use 'id' as the value, and 'name' as the label in your join element.

-- hugh

 

[jeffhoneyager]

Thanks! I was looking for the "join" element but found it as "databasejoin" works great!