I ran into a problem when I needed to add two fields WorkerSalesRespobsible and WorkerSalesTaker from SalesTable to an existing grid in SalesLineOpenOrder form in AOT. When I dragged and dropped the fields from the forms DataSource (SalesTable) it looks like this in AOT.
When I compiled and open the form it is not showing any records under these two fields. I queried the DB and data is there in these two fields and I think datasouces are also setup properly. Am I missing something here ?
Is your SalesTable data source inner-joined with the SalesLine datasource?
Martin "Goshoom" Dráb | Freelancer | Goshoom.NET Dev Blog
I have a relation in the SalesTable that says SalesTable.SalesId == SalesLine.SalesId are we looking for this ? or I need to look somewhere else ?
No, that just says how the tables will be linked if you decide to link them.
Please look at How to: Join Data Sources for a Form.
I join was there but the LinkType was delayed I changed it to innerjoin and did the trick :) So I think this is nothing to do with ReferenceGroup control right ?
That's correct. The reference group correctly replaced RecId with worker's name, but because of the type of link, you had only one SalesTable loaded at any time.