a list showing different elements from multiple table

[vocxen]

hi there, how can i create a list that will show/list different elements from multiple tables.

example:

table1:
remark1
remark2

table2:
remarka
remarkb

table3:
remark1a
remark1b

list:
remark1, remarkb, remark1a

using joomla 3.9.15, fabrik 3.9 (github update)
thanks.

 

[lousyfool]

You're listing tables (= Fabrik lists) and records (=rows) in those tables.

I'm now talking tables (= Fabrik lists) and elements (= columns) in those tables:

table1:
id (internal)
remark_numeric (field, text or integer or number)
remark_alpha (dbjoin to table2)
remark_alphanumeric (dbjoin to table3)

table2:
id (internal, "value" for above dbjoin "remark_alpha")
remark (text, "label" for above dbjoin "remark_alpha")

table3:
id (internal, "value" for above dbjoin "remark_alphanumeric")
remark (text, "label" for above dbjoin "remark_alphanumeric")

Table1 (e.g. List1 in Fabrik) will then show you the desired result.