>I think visio also "wants" fkeys to have the same name If I remember correctly
>Ken
>

Just my 2 cents here.

This get into some trouble when you have 1 to many to one environments. I have a few financne oriented apps. John Doe can have a few accounts 1:M but each account can only have 1 set of figures. 1:1

UID = primary key for each table.
CUID = customer FKey = cust.uid
AUID = account FK = accnt.uid

So vision will get you in trouble here. Generating updateable views is fun!


__Stephen