Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
0-1 relationship
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00090742
Message ID:
00090927
Views:
19
Jose,

>I'm using a Left Outer Join. I have a "Clients" table with "id_cliente" as the Primary key. I have another table "Extra Data" that will hold extra data that I need only for Brazilian clients, that has also "id_cliente" as the Primary Key. So if I have 6 clients and only 2 are from Brazil, I'll have only 2 records in the "Extra Data" table. In my view, all 6 clients appear and the fields from "Extra Data" appears with .NULL. for those non-Brazilian clients. Got me ? My problem is : I insert a record in the view, I save my insertion, a record is appended to the "Clients" table. How can I insert a record in the "Other Data" table if the country is Brazil ?>

In the PostSaveHook() method of the Clients business object, check to see if the country is Brazil, if so, call the "Extra Data" business object's Save() method. You can place any necessary preprocessing code in the "Extra Data" business object's PreSaveHook() method.

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