>Hi Alejandro,
>I wouldn't use a DBC. You should design the locking such that related tables are sure to be updated. I would also feel free to break some normalization rules along the way. Think about the way VFP does the PJX or VCX files. The Project file has one HomeDir field--only used by one record. That's wrong--but oh so right for the task. We like having the project in a single (or two with the PJT file) file. The VCX/SCX files have a comment record, dataenvironment record and so on. If VFP normalized these files, each ClassLib would be sourced in a variety of files--but I'm glad they don't.

By working more on it, and using views, I can get it down to one dbf and one cdx, or could even eliminate the cdx by creating the indexes on open.

Certainly from the point of view of the user this seems better. Do you think I am overdoing it? Thanks for your idea.

Alex