Re: Showing recordsets from tables with one (main table) to many (secondary table) relationship

[Kostas Telias]

> That might be the 40-50 solution, with good efficiency.

I don't know exactly how i would go to the record 40 of 50 if i include, like you purpose, a field with all the classification.

On the other hand, i would like to know if the best solution between the solutions understood for me (table with two fields, Ids and order), is more efficient comparing it with your formulation, and with the array formulation, for a schema with 2.000-3.000 records.

Thank you.