Forum

Search UsersRules

Sub table or detail table add record?

Erdoğan Uğuz

Dec 12, 2022 02:50 AM

Active user

Points:: 0
Joined:: May 9, 2018

Hello.
I have a document table. It has sub tables in it. I can add rows to the document table with code. How can I add a record to a subtable?

Code
RowMaster= Documents.MasterDocumentTable.FindByAttribute("Col1", "ABC"); RowMasterRef = RowMaster.Ref.GetObject(); SubNewRecord = RowMaster.DetailTable1.Add(); ?? ... ...

Profile

Erdoğan Uğuz

Dec 29, 2022 11:53 PM

Active user

Points:: 0
Joined:: May 9, 2018

Hello. I am writing the solution to the problem.

Code

RowMaster= Documents.MasterDocumentTable.FindByAttribute("Col1", "ABC");
RowMasterRef = RowMaster.Ref.GetObject();
SubNewRecord = RowMasterRef.DetailTable1.Add();
SubNewRecord.Col1 = "A";
SubNewRecord.Col2 = "B";
RowMasterRef.Write(DocumentWriteMode.Posting);

Profile

Aleksandr Biryukov	#3 Dec 30, 2022 02:48 PM
Administrator Points:: 0 Joined:: Oct 3, 2019	Hello Erdoğan, could you show a screenshot from the Designer with the structure of this document?
	Profile

Erdoğan Uğuz	#4 Dec 31, 2022 11:44 PM
Active user Points:: 0 Joined:: May 9, 2018	Hello. I changed the design. My first model was useless. Inadequate in query usage. That's why I split the tables. But the code I wrote is correct.
	Profile

Users browsing this topic (guests: 1, registered: 0, hidden: 0)