×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Need Addtional Fields for Order Entry Header

Need Addtional Fields for Order Entry Header

Need Addtional Fields for Order Entry Header

(OP)
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.

RE: Need Addtional Fields for Order Entry Header

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.

RE: Need Addtional Fields for Order Entry Header

(OP)
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.

RE: Need Addtional Fields for Order Entry Header

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.

RE: Need Addtional Fields for Order Entry Header

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

RE: Need Addtional Fields for Order Entry Header

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!

RE: Need Addtional Fields for Order Entry Header

(OP)
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.

RE: Need Addtional Fields for Order Entry Header

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close