To add fields to an existing subform

tuula

I need to add two fields into the sales order subform. The first field is the date when the article is expected to be delivered and the second one is the amount on purchasing order.

The task is surely very easy, but I have just started to make changes in Navision and don’t have too much experience. My problem is that I don’t exactly know which information is needed and I have managed to add the amount field into the form, but the field is always empty though I know that just that we have ordered just that particular article.

I suppose I need to connect the tables somehow. Is it enough to join the tables or do I have to do something else too? I only want to read the information, no updates. When I look at the fields on that form, so I only can see those fields, which belong to the sales order subform.

My rights to do changes in the database are restricted, for example it is not possible for me to design any code units.

I would be thankful for some advice.

kriki

The amount field of the sales order line is only calculated when you release the order. So probably you didn't release the order. (I suppose(=hope) you DIDN'T create a global variable you named "Amount").

A form is always connected to maximum 1 table (or no table at all). So if you want to have some other data, you need to program it (or create a flowfield in that table and use that field).
-flowfield: this is a read-only (99.99% of the cases)-field that is calculated on-the-fly. This is quite easy to create, but it has limited possibilities for calculation.
-calculate the field in the form. For this there are 2 ways:
1) create a global variable, and put that on the form. In the "OnAfterGetRecord"-trigger you calculate the field (in variable "rec" are the fields of the current record)
2) create a new function that accepts a record-variable of the table and returns the variable type you need. Put that function in the "SourceExpr"-property of the field "TheFunction(rec)". (in variable "rec" are the fields of the current record) and in the function you calculate the value.