>>>Going to layout my main diagram again tonight (now that I can move around in it :) ) and try this Virtual Fields trick tomorrow. =D) One Happy Camper!
>>
>>you're welcome, it was so easy !
>>
>>there's probably a number of other goodies you have not discovered yet in xCase. You can also change the colours of your tables in the diagrams. It helps make the diagram easier to read if you can make different groups in a crowded diagram. Right click on the table to find your way.
>>
>>Christian
>
>Oh cool, I was hoping I could use different colors to represent my different categories. My diagrams are coming along nicely BTW thanks to everybody's help. Plus I helped myself to my bosses 20" monitor while he's away on vacation so thats helped too :) I havent gotten to try using a virtual field for a primary key yet, but it seems like it will work. And your right, there are alot of goodies in xCase... this Thread made me realize that now is the time to determine which of my 2.6 tables will be replace by views. Boy was I happy to see how nicely xCase handles not only showing a view nicely in a diagram, but I take it xCase will also generate the SQL needed for each one!!! Yes, once again I'm happy camper :D)
>
>One thing though thats making extra work for me, xCase does not seem to like FPW 2.6 Index tags with an embedded function when I bring in my source tables.
>
>For example, this is a common tag on many of my tables:
>INDEX ON STR(ref_num)+initials+offnum TAG rptorder
>
>I'm using STR()because FoxPro doesnt like mixing numeric with character fields in an index expression. What seems odd is xCase does not seem to like the STR() function, but will let me create the same tag without it. Ever see this? I'm hoping I wont have to re-create these tags again when I Forward Engineer my model into VFP because of the STR()function not being there. Thanks again for all your help.

just a guess but this may be related to the index constructor, which lets you use some functions. As soon as you have in your index keyy a function not recognized by the constructor, you are left on your own to build your index expression.

Christian