better to create a small lookup table to just run query combo box in form

[tagteam]

I have a form that has about 60 combo box fields from 6 different tables in one form. Will I get better performance If I create a bunch look up tables and use those as the source of the combo box or is it better to just select combo box and create the query there in the form?

[June7]

I always build combobox RowSource as an SQL statement directly in the control property. This still requires a 'lookup table' unless you want to build a Value List as the RowSource or your source of values is the destination table field.

A form can do data entry/edit for only one table. Why does your form have 6 tables?