HampMac

Thank you, thank you, thank you! That did it! You are a genius. This project is a present for my fiance to help her kick off her new business, and you have saved it for me. I cannot thank you enough.

Vaughan, Thanks for the assistance. I have tried your suggestion, and my file still will not come up. I tried several different scripts from my original file, one of which has a step to open a new window, but it seems that the open script is still being launched which closes the file. I feel like such an idiot for not having a backup of this file. I have tried holding down the escape key and command-period when I launch the file to stop the script, but this has not worked either. Any other suggestions or assistance will be greatly appreciated.

I accidentally put a Close Window script step in my Open Script, and now my database immediately closes when it is opened. Am I screwed, or is there a way to have my file ignore the Open Script? Thanks for any help.

My deep appreciation to everyone's response to this question. You have all been very helpful.

Thank you very much for this information, IdealData! I really appreciate you taking the time to answer my question. Have a great day... :)

I'm trying to do a Find script where one of the first steps is to Go to Related Record. If there is a related record, then the script runs fine, but if there is not a related record, then Filemaker seems to ignore the script step entirely and the rest of my script gets hosed. I'm try to get Filemaker to report that there are no related records so that I can take the script down a different path (ie. Show Custom Dialog Box stating "no records found). I've tried using Get ( FoundCount ) and Get ( RequestCount ), but these don't seem to do it. Can anyone suggest a way to have Filemaker report no related records exist? I sure would appreciate any advice anyone might offer. Thanks

Thanks for your reply comment. I'm not working on a serious Filemaker project at the moment, but rather trying to hone my skills. I do have the Project title on the Tasks layout, and you're right that does work fine. What I don't understand is that every record after the first behaves the way I expect it to. It does successfully pull the Project title from the parent file using a lookup. So, if I understand your explanation, the parent file is not committed until it becomes related to a child record first. When this is done, the relationship is created, and the lookup field will then work. Is this correct? I really appreciate your helping to understand this. Thank you!

I'm sure there's a logical explanation for my issue, but I can't figure it out. I have a file with two tables, Projects and Tasks. These two files are keyed on the ProjectsID. I have a portal on the Projects layout where I can create tasks. In the Tasks table, I have a Projects lookup field to pull the Project title into the Tasks table. If there is a record (even a blank record) in the Tasks table, then everything works fine, but if there are no records in the Tasks table, when I create the first task record from the portal on the Projects layout, it will not look up on the ProjectID and pull the Project title into the first record, and the first record only. Can someone please explain to me what is going on here? And any suggestions around this issue would be greatly appreciated. Thank you.

Hello, I have scanned the "eMail and FileMaker" section for an answer to my question, but I did not find one. Please pardon me if I overlooked a previously posted answer to my question. I am working on a file in FileMaker Developer 7 that has two tables. The first is a Content table with fields that make up the body of an email, and format of the email is fine. The second table is an Address Book table that contains three fields: Name, EmailRecipients (email address), and Group. I've set up two relationships between the Content Table and Address Book Table. One relationship keys off of the Name field and the other relationship keys off of the Group field. The idea is to give the user a choice of sending an email to a single person (in which case a group is not chosen), or to send to a group (where a group is chosen). Sending an email to a single person performs a script that works exactly the way that I expect it to work, however sending to a Group performs a different script that is supposed to place the Email Addresses of a found set from the Group relationship into the BCC field. Basically, my script is as follows: Go To Related Record [show only related records; From Table: Group; Using layout: "AddressBook" (AddressBook)] Go To Layout [View (Content)] Send Mail [To: Name::emailRecipients; BCC: Group::emailRecipents; Subject: :; Message: :] Name and Group are two different relationships representing the same AddressBook table. All of the email fields fill in properly except for the BCC field. When I choose a group and perform the script I get something that looks like this inside of the BCC field of my email: ",,,<ben@macfriends.com>,,,,,,,,". All of the commas seem to correspond to the number of records that I have in my Content table, and I don't understand why FileMaker isn't pulling the EmailRecipient data (email addresses) from the Group relationship. If I go to the AddressBook layout once the script has completed, I can see that the script has found the correct Group, and only records from the chosen group are in the found set, so I don't understand why it is not placing this data into the BCC field inside of the email. I hope this message is understandable, and I truly hope that someone can help me to understand what I am doing wrong. Thanks a bunch,

Hi, I found a free barcode font from: Free 3 of 9 Barcode (free3of9.ttf) Created By: Matthew Welch Web Address: http://www.squaregear.net/fonts/ I've installed the font in my System Font Folder. When I am in FileMaker, AppleWorks or TextEdit the font doesn't even show up these app's font list. However, when I am in Illustrator the font shows up in the list, but when I type, nothing shows up on the screen. The kicker is that when I am in Photoshop the font is in the font list and it displays correctly when I type on the screen. I am using all Mac OS X apps, and I can't figure out what the heck is going on. Any suggestions or help would be greatly appreciated. Thanks,

Thank you very much for your suggestion. Handling it as a relationship is brilliant. You are the man. I was too caught up trying to make a find work, but a relationship would be a great way to handle this. Thanks again.

This seems like this would be fairly basic, but I'm really struggling. I'm making a photo database as a tutorial project. I'd like to be able to categorize each photograph in a record with a user-editable pull down menu value list (i.e. landscape, seascape, portrait, etc.). Then on a different layout I'd like to have a global preference field that offers the same category value list, but in the form of a check box entry that would allow multiple entries. Then I'd like to write a script that says, perform a find on the category field based on the multiple checked entries in the preference global categories field, and then from that found record list pick a photograph at random to display at startup. Well I'm having trouble moving the values from my preference global category field to the category field and setting up multiple finds in the category field. I know that I could hard code this as a nested if query, but any new values added by the user would not be included. Has anyone dealt with this issue? I can handle the random issue, but this find is killing me. Thanks for your help.

Fenton makes some good points. Using the built-in login would be the easiest and most secure way to go. The open script would be something like: If ( Get ( AccountName ) = "Salesperson-1" GoToLayout ( Salesperson-1 ) ElseIf ( Get ( AccountName ) = "Salesperson-2" GoToLayout ( Salesperson-2 ) And so on. Then on each layout there is a portal to Table-1 that uses the Salesperson's name as the Relationship Key. Then individual salespeople would only be able to see their own records in that portal. You could then create additional locked find scripts to generate reports or lists that only show that individual's clients' information.

Hi, I'm sort of a newbie, but the way I'd handle this project is to create three different identical layouts that are locked down pretty tight. When salesperson-1 logs in, she is taken to layout-1. On layout-1 there is a portal to table-1 that uses salesperson's name as the relationship key. Make sure that only related records can be viewed. When salesperson-2 logs in he is taken to identical layout-2 that only allows him to create, view and modify records associated with him. And so forth. As with everything Filemaker, there are probably a dozen different ways to accomplish what you are trying to accomplish with this project, but I hope my suggestion will at least get you started thinking the "Filemaker way". Also if someone knows a more efficient way to handle this project, please share your ideas. HampMac

Hi again. For those of you who are interested, I discovered what I was missing in FileMaker Advisor magazine. I didn't check the "Run script with Full-Access Privileges" checkbox in my Account management scripts. Once I checked this checkbox, my script works great when I log in under an Admin account. Thanks for your input Shadow. HampMac

Hi Shadow, thanks for your reply. That's the way that I have set up this project. I have different layouts for Admin accounts and User accounts. On the Admin layout I have buttons that allow for creation of "User" accounts only which is a lesser privilege set than the Admin privilege set. However, when I log in under an Admin account, and I press my Add Account button, I get the dialog that verifies the new account name and its password, but then I get another dialog that states "Your access privileges do not allow you to perform this action." I do not get this message when I log in under a [Full Access] account. I have defined the Admin account to be able to perform all executable scripts. HampMac

Hi all, this is my first post on this forum. I am working on a time-billing solution that is designed to have two levels of privileges, an Admin level and a User level. I would like to use Filemaker's built-in security scheme, but the solution needs to allow Admin to create User accounts. However, I don't want the Admin level to have [Full Access] privileges. It is my understanding that only [Full Access] accounts can create additional accounts. If there is a way around this rule, I would appreciate any info. Otherwise, I guess I'm going to have to generate my own password fields, password scripts, and accounts to make this happen. Thanks, HampMac