>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
Hi Leonid,
There are several ways to fill in primary/unique keys.
1. If you are displaying or allowing user to amend primary keys
You have to make a call to procedure/function to get next id from 'Save' or 'New' routine.
2. Otherwise
You can call database procedure/function from DEFAULT property of a fieldyou. It works fine. DEFAULT property comes into account only when null value is passed to it.
Bye
Jayesh
- Jayesh