Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Spac3man

  • Rank
  1. so is there a way to renumber the internal ID?
  2. What is the correct syntax to include a field inside of the custom dialog? This is what I tried: "Are you sure you want to delete Invoice:"; Invoice::INV_Num FMP keeps telling me it expects and operator so I tried: "Are you sure you want to delete Invoice:" and Invoice::INV_Num but the resulting window would just show 0
  3. After a lot of Googling, that is the conclusion I came up with too. I have too many scripts pointing to this layout so instead I grouped everything on the old layout, dragged it off-screen and copy/paste everything from the new layout into the old layout.
  4. I have designed a new layout in my DB and want to replace the old one with the new one. The problem I'm having is that every time I try to rename the old layout, all the scripts that referenece the old layout, change to the (old layout) new name. And then when I rename the new layout to the old name, the scripts still reference the old layout with new name. IE.. script01 ---> Welcome Layout (rename old layout) Welcome LayoutOLD script01 --> Welcome LayoutOLD (rename new layout) Welcome Layout script01 --> Welcome LayoutOLD So the script will never call
  5. Thanks for the info Wim. This was originally designed in FM3. I'm gonna let sleeping dogs lie this time.
  6. Hello All! I have a DB that has several files. Each of these files has only one table. For the sake of good design ( I'm fairly new to FM but not to DB design concept) I want to import each file into the main File as a table but not lose the relationships. What I have tried is to FILE/IMPORT RECORDS/FILE as table and join the new table to the appropriate keys in the Relationshp diagram. The problem is that the fields in the corresponding layouts still point to the original file. If I delete the original file and rename the newly imported table to the original file name, the links ar
  7. Is there a way to control the original window? When you open a file, you cannot specify what kind of window opens (FMP12) nor the controls.
  8. Hello, I am redoing a DB that was made in FM3. I am trying to determine what scripts are actually being used in the table and which ones are extraneous. Is there a report to that would tell me this? I've tried the database design report in FMPA12. It lists all the scripts but doesn't tell me if they are used. Any info is appreciated. space.... out EDIT: I found it in the report I mentioned above. For those that are looking for the very same this I was, create this report for the scripts. In this report, there is a field that says "Layouts that use this script" Ta Da!
  9. I've manage to answer my own question but now have a new one. What I have discovered is the following: I assigned a menu set by privilege as mentioned above. I also chose to Hide/lock the status bar on file opening. When you hide AND lock the bar, you cannot use the Go to Record Menu with /Next/Previous submenu. If you hide, but don't lock it, then it is accessible. So the new question is.... Why would they do this, and how do I get around this issue. Off I go detective.....ing again! ugh
  10. Does limiting an account to data entry also affect this issue? I have the "Go to Record Menu with /Next/Previous submenu in my custom menu. I apply the custom menu to the account at the opening of the file by script with Get(accountname) and Install menu set. The options are there but greyed out and I cannot scroll. What have I done wrong?
  11. That is a great way to validate. I would never have arrived at such a simple method. I could not, however, get your Custom dialog box to work. It's like it was stuck in a loop. If I entered info into the diag box and then tried to leave the unique field, it falsely found an existing record. I'll keep trying to figure it out, but thanks so much. I hope other newbs benefit from it too
  12. I guess that's why they pay you the big bucks! Is this an efficient way to validate? Commit Records [skip data validation; No Dialog] Show All Records Sort Records [No dialog] (timestamp;decending) Go to Record [First] Set Variable[$PartNumCheck; Value:Products::Part Number] Go to Record [Next] Loop If[$PartNumCheck = Products::Part Number] Show Custom Dialog ["blah blah blah... back to order form"] Go to Record [No dialog; Products::Part Number = $PartNumCheck] Delete Record [No dialog] Close Window Exit Script [] End If Go to Recor
  13. Hello, In a script, I am trying to set a local variable as one of the fields of the most recently created record. What script step will get me the most recent record? Every record has a timestamp create field but I don't seem to find any appropriate script step that will get this done. Could it be as simple as: :Show All Records :Sort Records (Decending by timestamp) :Go to record [First] :Set Variable [$local; Value:Appropriate field]
  14. Hello All, I am developing a small DB for a re-seller of commercial products. Customers call the User to order products, the User enters an invoice in the DB and then orders the products from the Manufacturer. (No inventory is kept on-hand, either physically or in the DB) The User receives the products from the Manufacturer weekly but with some items backordered. I've already handled subtracting the B/O items on the original invoice. When the B/O items finally arrive, how do I script an invoice maintaining the Orders::_PK that is already half billed/paid? My first thought is to cre
  • Create New...

Important Information

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