Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About hsmith40

  • Rank

Profile Information

  • Gender
    Not Telling
  1. That works Great! I am glad you were observant enough to catch that "All Boxes" list that I had created. My intentions were to use it in some way but I was not aware of the functions you suggested. Alas, I need to stick to my book and it's tutorials and quit trying to program the project :-) I have one final question: in reality, the serial number is unique to every box that we have built, therefore, the boxes table currently contains about 900 entries. Is it unreasonable use a value list that large? A little background: before becoming a Jewelry and Keepsake box builder, I worke
  2. Thank you Wim, it appears to be an excellent document. I will take time to read it over carefully.
  3. Again, thank you. Here's the scenario: 1. New record 2. Fill out form, including VALID serial number, tab to next field. 3. Cursor is now sitting in next serial number field which, of course, is blank because I am finished with that record. And, blank is an invalid serial number 4. Attempt to enter new record. 5. Script is activated, error msg posted, cursor goes back to blank field. 6. I am stuck. Since I am new to FM, there is obviously something I am missing.
  4. Thank you for taking the time to check this out. Perhaps it would be better if I explained what I am trying to do. I simply want to verify that the serial number (which in reality is A/N) is valid. Disregarding my current attempt, what is the best way to accomplish this?
  5. I have pulled everything except that which is necessary to run the test. Notes: 1. Go to the "Orders" layout. Tab to the "Serial Number" field. Valid Serial Numbers are 1, 2, 3, 4, 5 and 6. However, it doesn't matter if the field contains a serial number. 2. As long as the "Serial Number" field is active, if you a. Delete a record b. Enter Layout mode, or c. Quit FM the script will be invoked. Currently the script simply exits. The original purpose of the script is to test for a valid serial number Thanks again. boxestb copy 2.fmp12.zip
  6. Sorry, I meant to say a Database that contains a scaled down Products table. :-) The Inventory part of the database is live data. I am adding the order entry part.
  7. Thank you LaRetta. I will create a scaled down Products table that I can zip and post. Thanks
  8. It does the same thing with both FM Pro 12 and FM Pro 13 Advanced. I can supply field info, screen shots, etc if you think it would help. H.
  9. OnObjectSave works. with OnObjectExit, not only does it fire the script if I delete the record or the relation, but it also fires the script if I attempt to go into layout mode. No matter, looks like OnObjectSave will do the trick. Thank you for your help
  10. I am doing an order entry system. I have an "Order items" table that relates to a "Products" table via a "ProductNum" field. I am using a portal to display the product info when the "ProductNum" field is keyed in. It works fine as long as the ProductNum exists in the Product table. Otherwise, I get no product info. I set an onObjectValidate trigger on the "ProductNum" field to run a script that would validate the ProductNum. The script does a count(Products::ProductNum) but it always returns 0 even if the Product Number is valid. For testing, I changed the trigger to onObje
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.