Search results for query: *

I want to add a combo box to the Item Master form, and populate it with the values from a User Defined table. Then when the user selects a value, have that value stored in a SECOND user defined table along with the item number (all of my notes and user_defined fields are already used up). Can...

Hmmm. How can I tell for sure? The cancelled one is status X', and the new one is status 'P'. I am actually expecting to 'see' an on order qty for this particular item. Say PO #1 had 100 on order, and PO #2 had 200 on order, I would expect to see 200 in the 'On Order' column of IMINVLOC_SQL...

Definitely spend some time with your reseller's Progression guru. It will be worth several times what you invest in time and money. I did it...they were great, and helped far beyond what I expected. Sincerely, mks

Wierd issue. We set up a new item, issued (and printed) a PO for that item to a vendor. Then cancelled the PO, and reissued another PO for that item. The user is swearing that the initial PO showed On Order quantity for this new item (never received before), but now with the cancellation and...

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...

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...

Are you doing ANY optimizations at all right now? Any Maintenance Plans scheduled on your server? I would be wary of claims of 'double the speed'. You can get soaked for a lot of money and not get any better results than what you can do yourself. I'm happy to pass on some scripts of what we...

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...