>Hi,
>I have a problem. I have to deliver a data entry program (Doctors and locations of their offices). All data is stored in three related tables: Med. Specialty, Doctor names and Offices. All tables are related through unique keys; table with doctor names has two "hooks": to the specialty and to the Offices. I have no problem retrieving data for viewing but when it comes to data entry... Should I include key fields in a veiw? If so, should I rely on DEFAULT settings for the key fields or value should be generated for such field? How it exactly works when it comes to appending new records to the tables?
>I'm really confused and I need help.
>Thanks in advance
>Leonid
Yes, you should include key fields. In fact, they are required for the view to get updated.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer