Limit to number of lookup tables?

[CutAndPaste]

Got a problem in a database, of my 45 fields, 31 are in number format that are fed by lookup tables. When I try to write a query with the "English" names showing instead of the numbers, Access just stops responding.

When I reduce the fields displayed in the query, things start to move again so it seems that Access does not like lots of these types of fields in a query/report.

How can I get around this?

The main table has only got just over 1000 rows and is unlikely to grow to over 5 or 6000 during the life of the application so I may just use text values instead, though I know it's not the proper way to do things!

Any ideas please!

Simon

 

[Pat Hartman]

There is a limit to the number of tables in a single query. I don't know what it is but you may have reached it. Are you sure that your table design is correct. 30 lookup fields in a single table seems excessive. What types of data do the columns contain?