Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Need help: Views or Tables? Please...
Message
De
10/07/1998 08:18:26
Leonid Kizelshteyn
Boston Medical Software, Llc
Massachusetts, États-Unis
 
 
À
09/07/1998 14:15:23
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00115553
Message ID:
00116080
Vues:
17
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
Fil
Voir

Click here to load this message in the networking platform