Dropdown list items from two tables

[hanees]

I have got three tables

Table 1
ID Name
1 John
2 Paul

Table 2
ID Name
1 Ricky
2 Waugh

Table 3 has a dropdown. that dropdown should load name from both Table 1 & Table 2.

How to do it?

 

[troester]

http://fabrikar.com/forums/index.php?wiki/database-join-element/#or-concat-label-examples

 

[hanees]

I could not understand the code on your page. so pls give me the code for my above requirement.
Thanks.

 

[cheesegrits]

Are you using a dropdown element or a join element?

How are tables 1 and 2 related? In other words, if loading row id 2 from table 1, how do you know which row to load from table 2?

Also, note that asking people to write code for you is expecting a lot.

-- hugh