Hi all,
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 ?
Regards,