Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need help: Views or Tables? Please...
Message
From
10/07/1998 08:18:26
Leonid Kizelshteyn
Boston Medical Software, Llc
Massachusetts, United States
 
 
To
09/07/1998 14:15:23
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00115553
Message ID:
00116080
Views:
16
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
Map
View

Click here to load this message in the networking platform