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