>Opinions, comments, general feelings on simple question.
>Should I have one big DBC or two medium DBCS in one big system with many users?
>One with all tables (Lookups and Data)? Or two separate ones. Data tables in one DBC, lookup tables in the other. The system usually involves opening only one or two forms at the most (multiple tabs).
>
>Speed, integrality, optimization, standardization (whatever that is). Any thoughts
IMHO it's totally up to your taste. Lookup tables generally doesn't have any referential integrity nor need extended DBC capabilities, therefore could even be free tables. If you'll contain them in a DBC making it another DBC would mean you could easily share them with other projects.
Cetin