combine lists

[ebonydabster]

Hi Experts!

Could you please tell how to combine lists

for example i have 42 lists with 100 rows and 5 colums avarage

How to combine them in 1 list and all of the rows will be automatically added from this lists because i have the same colums

it will be like that:

Total list (combinded 42)
1 list

1 row
..
250 row

2 list
251 row
..
350 row...

...
42 list
3500 row
..
3600 row total

Thanks!!

 

[cheesegrits]

There's no built in way to do that.

Why 42 separate tables? In most situations where you find you have multiple tables with identical fields, you can simply have one table, with an additional identifier field you can use as a prefilter to restrict what content gets loaded in different menu items / copies of the list in Fabrik.

The only way of concatenating multiple tables into one list would be to use a MySQL view that did a 'union' query, and build a Fabrik list on that view, but that would be "read only", you couldn't add/edit records with it.

-- hugh