Jump to content

hsmith40

Members
  • Content Count

    10
  • Joined

  • Last visited

Community Reputation

0 Neutral

About hsmith40

  • Rank
    member

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 worked many years as a Systems Analyst dealing with Oracle, MYSql, C++ and Objective C. When we started the box business, I wrote a dandy inventory system in Objective C using MYSql. However, the business has grown now and we need a more encompassing system with tables for Order Entry, Customer, etc. Hence the move to FM. FM converted all the inventory tables beautifully and gave us some very nice added features of find, etc. I am very happy with FM Thanks for your dilligence Hah! We get that all the time :-)
  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
×

Important Information

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