How to add fieldno's to the fieldmenu

Mike1

How can I add fieldno's to the fieldmenu, which i can use to edit my forms??

THX

kine

You mean the field menu in the form designer? You cannot... sorry.. but you can add the editbox (column or field) manually to the form (with connected label) through the toolbox and use "FieldXXX" as the souce expression to connect the editbox to the Field with name XXX. After you save and reopen the form, correct field name will be used automatically.

tinoruijs

Hi Mike,

You must add a field to the table which is used in the form (Form-property SourceTable).
After adding the field to your table, it will be visible in the field menu.

Mike1

Hi Tino,

I've added the fieldno to table no 18, yet, when I open the field menu in Form designer (form 143), it is still not visible in the fieldmenu. Is there something I am missing?? The field that needs to be added to the field menu is a Boolean field, does it have to do with that??

Mike1

Hi Tino,

Never mind my earlier question. Didn't add my fieldno in the right sourcetable.......... :oops:

tinoruijs

Hi Mike,

That's because the SourceTable of form 143 is "Sales Invoice Header".
So the new fields needs to be added to table 112.
And I assume you also want it on the other sales tables; 36, 110 and 114.

And in table 18? And you want to transfer the value on the customer to the Sales Header?
Then you have to edit Sell-to Customer No. - OnValidate() in table 36.

And the field-ID of the new field has to be the same in all tables to make sure the value is being transfered (TRANSFERFIELDS) to tables 110, 112 and 114.

tinoruijs

Mike1 wrote:

Hi Tino,

Never mind my earlier question. Didn't add my fieldno in the right sourcetable.......... :oops:

Yep. Noticed that. [-X

Mike1

Hi Tino,

Indeed, the value entered in the customercard, should also transferred in the sales header, and non-editable.

But I cannot seem to find, where to edit that field in the sales header form.

Can you tell me what properties to modify?? :-k

tinoruijs

Mike1 wrote:

Hi Tino,

Indeed, the value entered in the customercard, should also transferred in the sales header, and non-editable.

But I cannot seem to find, where to edit that field in the sales header form.

Can you tell me what properties to modify?? :-k

And in table 18? And you want to transfer the value on the customer to the Sales Header?
Then you have to edit Sell-to Customer No. - OnValidate() in table 36.

tinoruijs

The non-editable-setting is set in property Editable on the field in table 36.

Mike1

Hi Tino,

I know that I should edit table 36. But do I have to edit the properties of Field no "Sell-to-Customer"?? And, if so, where should I edit what....

tinoruijs

Mike1 wrote:

Hi Tino,

I know that I should edit table 36. But do I have to edit the properties of Field no "Sell-to-Customer"?? And, if so, where should I edit what....

No, you have to edit the code which you find in the OnValidate of Sell-to Customer No.. Use F9 on the field Sell-to Customer No.
And search for ""Sell-to City" := Cust.City;". Here somewhere you must make your modifications.

Btw, Mike; I think a development course can be very helpfull to learn the basics of development in NAV.

Mike1

Hi Tino,

I figured out the non-editable part already. But, how do i get the value entered in the customercard to be exactly the same on the sales header.

What are the exact steps to realize that??

tinoruijs

Mike1 wrote:

Hi Tino,

I figured out the non-editable part already. But, how do i get the value entered in the customercard to be exactly the same on the sales header.

What are the exact steps to realize that??

No, you have to edit the code which you find in the OnValidate of Sell-to Customer No.. Use F9 on the field Sell-to Customer No.
And search for ""Sell-to City" := Cust.City;". Here somewhere you must make your modifications.

Btw, Mike; I think a development course can be very helpfull to learn the basics of development in NAV.

The := copies the value on Cust (customer) to the sales header.

Mike1

I think I'm gonna ask the pro's.........

:shock:

tinoruijs

Mike1 wrote:

I think I'm gonna ask the pro's.........

:shock:

And plan the development course!

Joeri

I thought this was the place to ask the pro's

tinoruijs

Joeri wrote:

I thought this was the place to ask the pro's

It is.

Now he gave you a call?