>>Roxanne,
>>
>>I won't answer all your questions as I have no experience related to Data warehouses, but I'm using xCase with apps counting 30-40 tables and can give some advice.
>>
>>>My xCase related Questions-
>>>1.) Does grouping my tables into the above categories make sense to anybody other than me? Maybe I've gone over the edge... as in I'm reaching the point where I'm "over-designing". :)
>>>
>>Any grouping is good as far as it suits you and your customer. The key to your problem is in using multiple diagrams in xCase, one for each group. Everything still fits into one model but your diagrams are easier to understand.
>>
>>I have similar groupings (system tables, lookups, data ) but also make groupings by function/department for example marketing, manufacturing, quality assurance. Some tables appear in multiple diagrams. These diagrams are useful for discussions with the client.
>>
>>>2.) Can I setup each of my Table Categories as a separate model in xCase to make the user interface easier to deal with? Would this be a wise approach? If so will I still be able to Forward Engineer everything into one VFP DBC?
>>>
>>It think it is better to keep everything in one model, especially if you want to make a single DBC out of it
>>
>>
>>
>>hoping this helps
>>
>>Christian
>
>Thank you Christian, your input does help. See, I am both programmer and customer with this Project since I'm employee and not consultant. So I have alot of freedom with deciding "how to do" things, but too much freedom when it comes to figuring out "the best way" to do things.
>
>Your answers lead me to think maybe I need to just get all my tables into one model, and dont worry about how bad the main diagram looks.... Just use separate diagrams to represent my table groupings and other system functions in a legible manner? Or is it possible with xCase to have many different diagrams in a model without having one master diagram that shows all tables?

The main diagram will conatin all your tables unless you remove some of them. Diagram entities leads you to a mover dialog from where you can add/remove tables from a diagram. You can also create many diagrams, where you add just the tables you need.