PurchLineOpenOrder form- Unable to find all fields from PurchTable

Hi,

In the above form, I am trying to add the field PurchTable.WorkerPurchPlacer on

Tab->TabPage:PurchTab - >Group:Purch

I searched in the List of fields, but could not find many fields including the above. Any idea why it is not displayed?

regards

Thomas Philipose

Navigate to fields of PurchTable data source (AOT\Forms\PurchLineOpenOrder\Data Sources\PurchTable\Fields) and find the field there. I see WorkerPurchPlacer field without any issue.

(Question moved to the Developer Forum.)

Hi Martin,

You are right, I too can see all fiedls, if i navigate in the path mentioned by you. But try to go in the following path

In the design of the form:

Tab->TabPage:PurchTab - >Group:Purch

I added a string and in the Properties i selected the PurchLine table and browsed the field list. Here I am facing the issue.

Thanks

Thomas Philipose

If you select PurchLine as the data source, you’ll see fields for PurchLine only, not for PurchTable. You have to use the right data source.

Dear Martin,

I am sorry, I mean PURCHTABLE only. Just now also I tried again and it does not show the particular field which I am looking for.

Regards

Thomas Philipose

Aha, I see. You created a string edit control, therefore you can choose text fields only. The type of WorkerPurchPlacer field is Int64 (it’s a reference to a surrogate key).

Bless you

Thanks for the eye opener

regards

Thomas Philipose