Hi Pete, keep in mind that there are always situations that will force you to 'bend the rules' in order to meet requirements. For instance,

There are times looked up data needs to be dynamic, but there are times it is necessary to know what the value was at the time of the data being entered and it cannot be changed by normalization rules. For example with a military requisition order that also shows the commanding officer. A report from normalized data would not reflect the commander that made the requisition, but rather the current commander since commander's change every couple of years. A current force status report would want a dynamic value. You would have to be able to show WHO the current commander of the unit is, as well as who was the commander at the time the requisition was made so the report would consist of BOTH normalized and denormalized data.

Tracy



>Hi all,
> I've read what I can find, downloaded an article, but I still can't quite get the hang of normalizing table(s). Every time I try, It's never quite the way the text(s) say it should be. I don't know how to check if I've gotten it right or wrong. Is there some sort of procedure that I haven't stumbled on? I'm working in FPW 2.6 under Win2K. Will eventually move to VFP7.
>
> Is there a definitive article or something that explains things fully for thick skulled people like me?
>
>Pete