Adding linked text box to Item Master Maintenance

[mksnyder]

We are using a 'user defined field' on our Item Master form to denote a 'Royalty Code' (basically a code that determines if we pay a royalty on products we sell). I have built a Royalty table that has the Royalty code (as the PK for the table) and a Royalty description. I want to have the Royalty description display in a text box, and be able to lookup codes to populate the user defined field with, as well as be able to add new codes to the table.

This would be a snap in Access or VB, but I'm new to Flexibility and the Macola interface, and they want this on the IM form.

Any suggestions or pointers would be greatly appreciated.

Thanks,

 

[abaldwin]

There are several Flex guys out here but this site ask us not to leave our contact information.

I would suggest that look at

http://www.gainfocus.biz

or holler back as I would be more than happy to quote this for you.

Sounds fairly simple though probably using a UserForm for the lookup and add to populate the field on the main form.

Andy


Andy Baldwin

 

[dgillz]

Do you use the commisions ature in Macola? If not I would adapt it to calculate royalty for you. What is the formula for royalty?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[mksnyder]

Unfortunately, this database has been 'highly' customized already. They are using the 'commissions feature' as well as almost all of the user defined fields.

Thank you for the suggestions. I will probably build something in Access and link it to the IM form. Kind of kludgey, but gotta get something going.

Sincerely,

 

[dgillz]

Do you own Flexibility? If not you will not be able to do this.

Also, Access if fine for a front end, but I would make the data table itself a custom table in the Macola database, either a Pervasive or SQL table. Just name the table something unique like IM_Item_Royalty_SQL, so that Macola updates will never touch it.

I had a customer doing stuff like this and using the 8 character naming convertion that Macola uses, and it is tough to know which tables are custom and which tables are Macola's.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

 

[mksnyder]

Yes, we own Flex, and I have taken a 'beginning' Flex class. I had already created the table in SQL, and I named it IMROYALTY_PMI (IM to group it with the Item Master tables, and _PMI where PMI is our company initials). I try to use the _PMI for all custom tables I build, for exactly that reason.

We are using the SQL version, on a new SQL 2000 box. I just performed the cutover from an older box, and it went quite smoothly, this new dual-Xeon, 2GB RAM machine has cut most of our processing in half. WHAT a difference.

Meanwhile, back to the customization...

 

[stravis]

I would suggest that you create a custom search and attach to your user defined field via screen designer. To create the custom search login to Macola as SUPERVISOR and open any maintenance screen in any module. Open the search for the primary key value and click on "Search Edit". Once in the search editor you can click on "File | New" and create your search on your custom table. (If you need to access a table outside of the current database you will need to create a view in your SQL database that links to the other database or server) You will need to highlight the column you wish your search to return and select "Column | Return Col". Then save your changes and give your search a search key "MYSEARCHKEY" and a search title. The search title will display when the user pulls of the search and the search key will be used in designer to link your user defined field to the custom search. Once you have completed this search definition you are now ready to tie it to a custom field. Open the Item Master (IM0101), unhide a user defined field, right-click, and select "Search Name...". Enter the search key you specified when you saved your search and save your work. You can now display the code on screen.

To get the description you will need to use flex and I would suggest adding a variable label to the screen, as it does not require you to have focus to update its value, and use it for the code description. You will need to access your custom table and pull in the description based on appropriate events in the item master. If you need more specifics on this please let me know.

Scott Travis
infoSpring, LLC.