Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
BizObjs and Many to Many relationships
Message
 
To
30/08/1999 09:54:33
Rex Mahel
Realm Software, Llc
Ohio, United States
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00259145
Message ID:
00259464
Views:
16
>All,
>
>I have a many to many relationship between two entities, Vaccine and Manufacturer. I do this by using a VaccineManufacturer table and two one to many relations. I use the VaccineManufacturer id in my other entities to show the Vaccine/Manufacturer pair instead of having both a Vaccine and a Manufacturer field.
>
>I have business objects for both the Vaccine and the Manufacturer entities, but I am now wondering if I need to have one for VaccineManufacturer since I will need to requery the table after changing either the Vaccine or the Manufacturer in my entry screens.

Without knowing all the details it's difficult to give a complete answer, but if you have a simple link table between the two entities, you can probably accomplish what you need to do without a separate VaccineManufacturer business object. However, if this is a more complex relationship with special rules, you may want to create one.

Regards,
Kevin McNeish
Eight-Time .NET MVP
VFP and iOS Author, Speaker & Trainer
Oak Leaf Enterprises, Inc.
Chief Architect, MM Framework
http://www.oakleafsd.com
Previous
Reply
Map
View

Click here to load this message in the networking platform