Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About brandie

  • Rank

Recent Profile Visitors

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

  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 C
  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 C
  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
  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
  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
  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
  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.