Jump to content

Rich K.

  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About Rich K.

  • Rank
  1. Hello all -- I have 1 external IP Address ... currently port 5003 is being forwarded to FMServer 11 (on 5003) and this works fine. I just set up a FMServer 12 on a different Server and I would like to make this visible to the outside as well. With my external router, I can easily map external port 5004 to the 5003 port to the FMServer 12. It seems that the FM Client has some issues with aiming at a different port (or at least the ways that I have tried... fmnet:/ ). Any suggestions ? Thanks in advance, --Rich
  2. Hello all -- A little while back I moved from: MacOSX FM Server 10 Advanced on MacOSX ... to: FM Server 11 Advanced on Windows. My current production solution is 3 files in a Folder that all "know" about eachother. (In "External Data Sources" they reference eachother by file:xxx). In Filemaker Server 10 Advanced ... as long as your Files you wanted to "cross file server script" with were in the same folder on the same machine and you use the above "file:xxx" ... you could get away this. Well since the move to 11 and switching operating systems ... these Server Scripts fail. I ca
  3. Hi -- I have been reading posts the better part of today, that FM Server 10/11 takes advantage of Multiple Processors. However, that is usually followed by some murmurings about DB Design. Can somebody please clarify these DB Design "sins" that are so damaging, so that we all may avoid them to the best of our abilities. Thanks in advance, --Rich
  4. Thank you for your insight ... besides the fail expression functionality, I really don't see any benefit from using Lookup(). It would be really great if the Replace Script Step would honor this calculation; now, that would be a real game changer!
  5. I'd like for the Title to change to the DefaultTitle of the newly assigned dept.
  6. Hi -- Lets say I have 2 tables an Employee Table and a Department Table. The Employee has the following fields (pkEmpID, fkDeptID, Name, Title) and the Department table has the following fields (pkDeptID, DeptName, DefaultTitle). Assuming I have Table Occurences the same name as the table and have the 2 TOs joined by fkDeptID. What are the benefits of having the following: Employee::Title ... Auto-Enter calculated value Lookup(Department::DefaultTitle) over Employee::Title ... Auto-Enter calculated value Department::DefaultTitle :)
  7. Hello all -- Is there an easy way to close all Windows except the current window without closing the whole file? Thanks
  8. Hello - I have a table called DocType with the following fieds dtID (num) and TypeName(text). I have created a Value List called vlDocTypes from this table. I have another table called Vendor it has all the normal fields you would expect and then it has the following 3 fields: dtID_purchase (num), dtID_creditmemo (num), and dtID_payment (num). As you would guess each of these are supposed to have values from vlDocTypes. Now, I can of course could have 3 different TOs (of the DocType Table) for each of dtID_xxx fields... However is there a way to do this with a single TO relation
  9. Hi -- I was listening to a podcast and one of the announcers mentioned that he imports a FM Table into another FM Table in the same FM File. I immediately started thinking about the awesome things you could do with this. At this point you are a little free from the graph and do some pretty cool things with staging records in one table and transferring them somewhere else when you are done. I just wanted to get some feedback from the community about this. Is this a standard practice out there? How often is this done in real production systems? What does this do to othe
  10. Hi -- I have adopted a technique for "boolean fields". It entails the following ... make the field a Number (that can accept nulls) ... create a value list that has a single value of "1" (I usually call the Value List a Switch) ... and use the checkbox as the display type in layouts. I am sure you have all done and seen it. My question is how can you make the negative (null) value easily "queryable thru Find" on a ListView (for users)? --Rich
  11. BCooney -- Thank you for your insight ... I have Advanced Server running and I recovered an older backup copy and it works fine... now, I will spend the next couple of hours bringing my changes from the corrupt file over to the backup file. You are like my guardian angel for me on this project. Kindest Regards, --Rich
  12. Hi -- I just deleted some old table Occurrences ... trying to clean up ... and I may have left some scripts around ... yesterday (when i did it) everything seemeed to be working fine ... today however ... 1. My startup script won't copy container fields to global container fields 2. Perform Find doesn't work ... it cannot find anything. 3. Any form that has Child records (in a portal) ... won't show the child records. (but, they are still there ... I can see them on a different Layout). The Filemaker Profile attached is ocrrect and explains my environment. Thanks.
  13. I'm assuming that this table has 1 record. Is that correct?
  14. Hello all -- I have a list of records (from TO1) in a found set (lets call FS1) and it has a date range specified. I want to loop thru FS1 and create a record for each day for each record in FS1 to a related TableOccurrence (lets call TO2). I have Lookup() functions dragging a majority of the fields from TO1 to TO2. If I did this on screen I have a hidden layout that I transfer FS1 to ... and this hidden layout has a portal to TO2 that will allow me to add a record and all the Lookups will fire populating 95% of the new TO2 record. I created the script based on the the above par
  15. Hi -- Does anyone have a sample of a "StartUp Global Initializer Script" that will be used to init Global fields? Thanks in advance, Rich
  • Create New...

Important Information

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