More a configuration question than an installation question.
Consider a scenario where you have three tables: sales, product, product_specification. Product contains the high-level information about a product and product_specification contains different permutations of that product (e.g. colour, size, etc.). Product is a big table, but product_specification is a HUGH table.
You want to be able to reference a specific product specification in the sales table, but looking it up directly is difficult due to the size of the table (and product_specification does not contain information in the product table, which might help you to select the correct product).
Is there any way that DBFRONT supports making this more manageable? For example, by allowing the user to select the product in one field and a second field (product_specification) is then pre-filtered based upon what was entered into the product field?