>Hi, Edward
>We are thinking alike. I have created such structures and keep all my files in database normalized. My question is: if I want to have my data entry form based on a view, and form should allow adding new records, what should be the general method to create a view? Should I include primary key fields into it?
>Thanks
>Leo
As I said, entry form(s) realistically shouldn't be based on one integrated view.
Any view must keep primary keys just to provide data update. Actually, view designer should stop you, if you will not select primary keys.
Edward Pikman
Independent Consultant