Hi, i would like to create detail transaction every single data in list,
the output would be displayed in datagrid and filtered by selected data.
(currently display all data from any transaction).
currently the data store in one table.
as example bekasi have 2 data, what i do now trying create relation between master trans table and detail_Trans table but unsuccessfull, may i got wrong step?.
What’s the column type of the NAMA UPT in the master trans table? You can create a relation in the master trans table. It would be match with NAMA UPT column and detail_trans table Nama UPT column.
Also it would be great to use Row ID’s here because it’s safer and easier! So instead of storing the name in the detail_trans table, store the master trans table’s related row id and create the relation based on the row id.
Are you using a Form Screen or a Form Container?
I can’t tell from your screen shot.
If it’s a Form Container, then special values are added via the “Additional Columns” section in the right hand panel.