Log in to AnswerLog in to Follow
2019-10-10 17-46-40
Meta3Group
82Views
3Comments
How to create a CreateOrUpdate action when two or more tables have relationship?
Question
SQL
Best Practices
Database

How to create a CreateOrUpdate action when two or more tables have relationship?

We have three tables [1,2,3] and they're connected via a common Identifier. Two of them have a shared identifier [1,2] and one of them only have a connection to the other table [inheritance].

We're having trouble to create a CreateOrUpdate it seems not to work at all.

Thanks for the help.

Data.PNG

0
0
10 Oct 2019
2020-02-28 09-46-54
Eduardo Jauch
mvp_badge
MVP

Hi, 

1. You need first do the CreateOrUpdateEmpresa for the Empresa entity. 

2. After this in the logic, you need to assign the returned Id from the CreateOrUpdateEmpresa to the record of the Cliente entity, and then do the CreateOrUpdateCliente action, as this last one is an extension of the first, and so it needs the ID of the first as its own ID.

3. Than you can execute the CreateOrUpdateContato, as you need the returned ID from the CreateOrUpdateEmpresa as source to the EmpresaId foreign key in the Contato record.

Hope this helps

Cheers

1
0
10 Oct 2019


I'm in the same situation, I understand the logic, but I don't know how to get the ID generated from the first table that was saved, to save the others in the sequence. 



how to get the returned ip? 

0
0
18 Jul


I found the solution in another post, thanks. 

https://www.outsystems.com/forums/discussion/69361/form-that-inserts-in-2-tables-of-data/

0
0
18 Jul
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.