Share
Report
20Hi,
I have a form with a grid that has a datasource based on a view.
The primary datasource (the view I mentrioned) is based on the SalesLine and exposes the RecId of each sales line.
Now I need to add a table datasource to the grid.
The table can be related to the view via SalesLine.RecId.
The main idea is to allow the user to edit a field inside the new table joined to the view.
I've added the secondary datasource to the form setting the view as JoinSource and Link Type "outer join".
Than I've created a link between the two datasources using addLink:
QueryBuildDataSource qbd = fds.queryBuildDataSource();
qbd.clearLinks();
qbd.joinMode(JoinMode::OuterJoin);
qbd.addLink(fieldNum(TheFormView, SalesLineRecId), fieldNum(SalesLineExtended, RecId));
The grid is displaying correctly the data and the two datasources seems to be joined but when I click on "Edit" on the field I want to edit of the secondary datasource (based on the table) is not editable.
No error raised from the form.
I've set AllowEdit to true on the datasource of the form and the underlaying table.
Is is possible to edit field of a table datasource joined to a view? Is it the wrong way to achieve this?
Thank You in advance for your help.
All responses (
Answers (
