Jump to content

FestiveEmbalmer

Members
  • Content Count

    83
  • Joined

  • Last visited

Community Reputation

0 Neutral

About FestiveEmbalmer

  • Rank
    member

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. weak sauce people, weak sauce... I have 20-25 machines that due to the constraints of a legacy system must share their own databases at any given time. I have had no problem connecting between them up until now and hardware/software-wise there are three groups of identical systems. I have one and only one system that cannot see any other local hosts on the FM network, neither does it appear as a local host to other users. Filemaker sharing is enabled and the databases themselves are set to be visible. The firewall is set to allow FM sharing and in fact, I have simply turned
  2. Is there a way to get around filemaker's "specify field" method of selecting a field in scripts? Are there any techniques for calculating field names to be acted on?? I am trying to make my scripts more abstract and multifunctional, but am being thwarted far too easily! thank you for your help, matt
  3. I see the wheels turning! The globals don't need their own TO but they are in a relationship. See my attached example. There are two creation buttons to illustrate the basic idea and the implementation through a relationship. Notice that there is a relationship for the portal and a different one for record creation. Records created via the relationship meet the criteria for the portal and are displayed on record commit. Also worth mentioning is the RELATOR function provided by Alexander Zueiv. I use it to simplify things a bit, but I recommend you make sure you understand how Fil
  4. John is right; you really want your primary key to be meaningless. Like a soul! But seriously, think of it like a soul. The number is meant to individually identify that specific instance of the table entity in the database in a way that the system can quickly and easily relate other specific entities to. If it has a meaning to you, that almost always means that you will want to change it at some point to reflect a change in the meaning. The fact that the number is sequential doesn't actually help its function unless you need to know the creation order of your records, in which case you
  5. a couple of ideas: 1.) You already have a button outside of the portal for creating a new record, so you might consider putting global fields for the new contact information outside of the portal and changing the button script to create the new record with that information and clear the globals and commit the record. Then the user never has to spend time editing the records in the portal in the first place and it updates instantly. (Imagine that would help with record lock too.) 2.) Same as above, but put the globals into a popup window that displays during the "create new" script. S
  6. It looks like you have your solution pretty well done apart from actually making layouts. The short answer to your original question is as Søren said, Portals. Portals are filemaker's method for displaying related records on a layout. I did notice that all your relationships are single criteria equijoins. There is no problem with that, but understanding filemaker's different joins will allow you to leverage a lot of your experience in terms of functionality. In addition to building your db structure, you can also create relationships that are like permanent queries. For example, you
  7. It would seem I might have confused the two issues. I do not know if merely having filesharing turned on can corrupt FM files being shared via FMServer - all I know is that my org has both issues, and files shared in either method have been corrupted. I would love to have all those legacy files shared via FMServer but unfortunately, there are 1500 of them. Woe is I. A-developing-I-do-go-go. may your files stay nubile and pristine, matthew
  8. I'm sure there is a fancy answer for the sort, but I would just create a calculation field that takes the first letter of the field you want to sort thusly: Left ( LastName ; 1) Then I would make a print script which would perform a find for A in that field then go to the desired layout and print and then perform a find for B in that field and go the the desired...etc... I'm afraid i'm pretty terrible with layouts, I would just have to keep positioning and resizing till you get it. I know that Envelopes of type 7 are that size, but I doubt FM has a print set up for that. g
  9. Had me puzzled, but I got it. Your calculation for Full Name has the result as Number. Change it to text and it will work. peace, matt
  10. There are two solutions as I see it: 1.) Assimilate & Adapt http://hardcoremac.stores.yahoo.net/fipro60forma.html http://nostarch.com/frameset.php?startat=filemaker 2.) Cajole & Conquer http://www.filemaker.com/downloads/pdf/filemaker_versions.pdf http://www.filemaker.com/purchase/store/corporate.html Key words like "security", "email integration" combined with features like PDF reporting can make that upgrade an attractive sale, even if they aren't savvy enough to recognize the benefits of multitable dbs. Besides, they are going to have to pay SOMEONE to he
  11. I can back up those best practices with personal experience. I inherited a setup with filesharing and filemaker on the same server. Seriously: Filemaker + filesharing = critical data corruption. Until I get our new server up and running, resurrecting files is routine maintenance. here thar be dragons, matt
  12. I am not sure exactly what you mean, more context would help. If you are comparing two groups of people, for example, then you might want to have one table not two. Are the tables related already or do they just share attributes? For example, People and Equipment can both belong to the circus but they may not be related for your purposes, so "circus" is just a value in a category field that they happen to share. Are you wanting to be able to enter a value on a layout to determine what records share that value in multiple tables or do you need to find all other records that share the values in
  13. Go to the unzipped Zippscript folder. There should be a fm db entitled "zippScript Example". On the main layout under "Examples" are the techniques you would use to trigger scripts under certain circumstances. For example, to trigger a script when committing a record, you place the script in a field validation calc. for the appropriate field formatted per the instructions in the example.
×
×
  • Create New...

Important Information

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