>Does somebody else tried to implement Entity-Attribute-Value (EAV) model with VFP? Or it is better to go with XML if I need something more flexible than flat tables?
I am not familiar with that concept but when it comes down to go far beyond that what the structure supports, I use a data dictionary table for it. The XML is a good approach. But, I prefer to use a data dictionary as it allows me to benefit of the same data mechanism as is the data. So, I wouldn't have to apply some XML data access and such. This will also allow me to obtain fully optimizable queries.