Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by mksnyder

  1. mksnyder

    Flex problem

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

    Cancelled PO & On Order Quantity

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

    Need help to jump start with Macola Progression!

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

    Cancelled PO & On Order Quantity

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

    Adding linked text box to Item Master Maintenance

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

    Adding linked text box to Item Master Maintenance

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

    Optimizing SQL Database

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

    Adding linked text box to Item Master Maintenance

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

Part and Inventory Search

Back
Top