>We used to call tables like contfee "connector records" in the hierarchical db design days. Looks like a good approach, except I think the fk_contract in contfee table is redundant. Hey, this is my first time commenting on UT - I had just been a browser before.
Cool. Trey pointed that out, as well. Thanks. I'll have to remeber the "connector" term.
Roi
'MCP' Visual FoxPro
In Rome, there was a poem.
About a dog, who found two bone.
He lick the one, he lick the other.
He went pyscho, he drop dead!