>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