Jump to content


  • Posts

  • Joined

  • Last visited

Recent Profile Visitors

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

brandie's Achievements


Contributor (5/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges



  1. Wow. I'm going to have to digest this one. Thank you so much for that head start!! I have a lot to learn on the reverse engineering here. :P
  2. Okay I used your example and I think I'm on the right track here. Any new ideas for the auto assignment? Appraiser2_Copy.fp7.zip
  3. Firstly, I really appreciate your help and insight on this. The first situation you brought up - where C is next in line but gets skipped - shouldn't be a big problem. I can't imagine much of a situation where C would get skipped anyway, but if he were, we would just cycle back around and get him next time. Although we want to divide the jobs evenly, there is no requirement that everything has to be exactly 33% for each. Would you mind explaining a little more about how to do the "self-join" relationship? I'm not familiar with it. Also,that join table that you mentioned between County and Appraiser - would the Jobs table (the clients list) serve that purpose? Or would it need to be a separate one?
  4. Ah so the appraisers to county must be a many to many relationship? I can see that now. Will that help me structure my query? I guess I'm also not sure how to create a many to many relationship. Do I need to create a repeating field as the ID Number for county?
  5. Hello everyone, I know that there is probably a very simple way to do this, but my knowledge of scripting is very limited, so I'm hoping perhaps someone can help me out. I'm setting up a database that will contain a list of appraisers in one table and a list of loans in another. The appraisers will be approved to work in various counties - a one to many relationship. The appraisers will also be assigned to various jobs - again a one to many relationship. What I'd like to be able to do is enter a job, and have the database basically say: "Okay, the loan is in Franklin County. The following appraisers can work in Franklin County. The next appraiser due for a job is Mr. Smith." Basically, there will be three appraisers approved in each county, and I need it to cycle through those three appraisers. I'm thinking a serial number might help, but I'm having trouble figuring out how to implement it all. I will attach the database I have so far in a following post. I realize that my relationships are not working properly - I just can't figure out how to make it all work. Can anyone point me in the right direction? Thanks so much. Appraiser_Clone.fp7.zip
  6. I had noticed that about toggling the sliding and printing options and got the same results as you. Thanks for the heads up about cutting and pasting LaRetta. That did the trick!
  7. Whoops. Sorry! The layout is Apartment Comp Sheet - 2 Page. The main table in that is Haines-Improved and the portal shows the table Apartments.
  8. Hello everyone! I'm stumped on this one. I've got this layout with a portal. (I've attached a copy to the post.) For some reason, even though I do not have "sliding left" turned on, the fields within the portal are sliding when I print. It shows up this way in print preview as well. I've tried turning sliding off and on for both the portal and the individual fields but neither has helped. The fields don't appear to be collapsing, but just "jumping" over a little bit for printing. Any ideas? Haines-Improved_Clone.zip
  9. Thanks for your help wallabri. I'm checking out the Chapsoft product and have emailed their folks to clarify a couple of questions that I had about it. Your program that you created may help us to some degree, but we need the ability to work with both single records and a set, of say, 5 records. Not a ton, but obviously just more than one. I'll keep you in mind though in case we find that one is better than nothing. :)
  10. Hi all, We've been very happy using FileMaker so far, and really don't want to go through the process of converting everything over to Access. But we really need Merging features - and I'm afraid I'm not finding what I'm looking for. Before I give up - I hope you can help point me in the right direction. : Merging features between Word and Access allow you to link to "active" data - so if you revise things in the database, they will flow through to the Word document. Obviously, if you export a .mer or .dbf file from FMP, that source file will not update when you make revisions to the database - thus the "link" is broken between Word and FMP. When I go into the Mail Merge Wizard in Word, the list of file types that I'm allowed to use does not include .fp7. Does this mean that there's no way to have an "active" link between Word and FMP? Can you only export, and just have to export again whenever the data changes? Thanks for your help in advance.
  11. But when you connect remotely into a shared file, the data is still traveling through the network. Does opening it remotely allow the "host" to do some error checking before it actually writes to the file?
  12. I meant locally in the sense that they aren't documents that are on a shared network drive. I'm having trouble grasping *why* the data might be corrupted if there is a single user accessing a document shared via the OS. As we only have 4 users, I think that FM Server might be overkill at this point in our usage. Backup capabilities are nice, but our programmer can also throw together a quick Python script that will handle the backups for free. : We've actually never had two users in the database at the same time up until yesterday. We just left sharing off and the file would be "locked for editing" if anyone else tried to get in. Now that we're thinking about using the databases in a shared situation, I want to step up our safeguards against corruption.
  13. Thanks for your responses Ender and Mr_vodka. I've spoken with the higher ups and I think I've managed to get them on board with spending a bit to make sure our data is safe. Just out of curiosity, why is it that FileMaker doesn't like documents that aren't stored locally? If only one person is in the file (ie, no sharing/hosting happening), I'm curious about what goes haywire. I think until we can get a good system in place, I'll set up a script that will automatically move a copy of our databases into a second folder each evening. That way, if something were to happen, I'd only have to roll back to the beginning of the day.
  14. From my time here at this forum, I've learned that the fastest way to make a FileMaker expert faint is to tell them that you have a database stored on a server and each user is opening it individually. So I won't admit that it happens here in my office. : But IF it were, I'd be repentant and want to change. Our (hypothetical) challenge is that our file server runs Linux. So installing a copy of FileMaker there that other people can open remotely from doesn't appear to be an option. Half of the other computers in the office are laptops, so the files can't be served from there as they go in and out of the office. The others are used very regularly, and I'm afraid that we would not get good performance since the CPU will be working on all kinds of other tasks. Plus, I expect that those users would be complaining about the program taking up valuable task bar space. What would you recommend for us? Keep in mind that because (*knock on wood*) nothing bad has happened in the several years we've had this set up, it will be difficult convincing the higher ups to shell out for much more.
  15. Ahhhh I was using that, but my silly silly mistake was that I was using a Date field type and doing an "AutoEnter" calculation, rather than making it a Calculation type field with results as a date. Ugh. Thanks for the help all.
  • Create New...

Important Information

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