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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only