Hi, Craig,
Thank you very match for your respond. My confusion was, basically, about how to use View designer to create data environment for the data entry form. My situation was:
1. Specialty file:
spec_id I
specialty c(10)
2. Doctors file:
spec_id i
name c(10)
... some other data belongs to that particular doctor...
3. Offices file
off_id i
doc_id i
address data for such office....
As you can see from the above example all three are connected:
Specialty(1-to many)->Doctors(1-to-many)->Offices
I thought that using veiw with primary key from all tables and allow to "update all" I will be able to use my form to enter data in all three: If doctor with new specialty arrives into the system, I should be able to enter all his data in this form. So, my several attempts didn't succeed and I have created a form based on tables, not view, thanks for Edward's advice.
Thanks for your attension
Leo
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement