Need Addtional Fields for Order Entry Header

[vanessa03]

I have Macola Progression 7.6 SQL 2008 R2/Designer & Flex. My problem is I have used all 5 of the UDF fields on the Oeordhdr table. I need 2 more fields for the order header, not line. If anyone has any suggestions on how to handle this I would appreciate your help. Thanks.

 

[NEmacGuy]

If you have flex, do you need all 30 char in each UDF field. Believe you could store two values in one field. Else create your own table and save and retrieve using flex.

 

[vanessa03]

So, If I break up 1 30 char UDF into 2, then how do I show two separate input fields on the order entry screen? Thanks for your help.

 

[NEmacGuy]

That programming. Use 2 VBA only fields, display only the left 15 chars in field 1 and the right 15 in field 2. Will have to concatenate field1&field2 and save in the user defined field of your choice.

 

[vanessa03]

That sounds great! But I have never added a vba only field. Where do you add that in designer? Thanks again!

 

[jbelk11]

It's been awhile since I used Flexibility with Progression.....but within Macola ES, when you are in Designer, you right-click an open area of the screen, left-click Special, left-click Add Entry Field. You should get prompted with a message about adding the field as the next number in the screen set...just click OK.

The VBA-only comes into play on the properties of the new field....right-click the new field and then left-click Properties. One of the check boxes is for VBA-only. You can also change other "attributes" of the newly created field.

I always change the value of the literal that goes along with the entry field....this will end up being the object name within the Flexibility project. You can always hide the literal if you don't need it.

Enjoy!

 

[vanessa03]

When I log on as Supervisor and go into Designer, I right clicked on the page, go into Special and "The Add Entry Field" is grayed out. Is there something else I need to do? Again thanks for your help.

 

[NEmacGuy]

Check with your reseller / Exact on that one, but remember you could also call your own form with VBA