phunkidude

I'm trying to open a database file that has a script set to fire on opening. The script is 'hanging' the file so I need to open it without the script running. Is this possible?

I'm moving our Filemaker 5.5 server to a new PC and have found certain databases that I do not wish to share. Is there a way to prevent certain database files from being shared? Thanks

That's what I ended up doing but the portal does not show all the records. Maybe I created the relationship incorrectly...

I have a layout with two tabs. I was wondering if it is possible to have a form view layout on one tab and then a list view layout on the other tab.

Barbara, that's exactly what I was looking to do. I just have to figure out how you did it now. Thanks for your help! Sean

I am trying to have a Value List be auto-generated based on data entered in another field. This is my problem: I am making an Employee database for which each employee has a job title which is selected from a Value List (for example Account Manager). I also have a Contacts (or Companies) database and an Account Manager is assigned to each of those Contacts. I would like to assign the Account Manager from a Value List but I would like this Value List be generated based on whether an employee is assigned as an Account Manager (or not) so as new employees are added (or terminated) and assigned as Account Managers the Value List in Contacts will update. I hope I explained that clearly enough.

Fenton, did you get a chance to look over my database, by any chance? I'm eager to see your solution.

Thanks. That's a useful little page.

In FM9Adv is there a way to Copy something from one layout and Paste it in the exact same position on another layout? Thanks Sean

John, thank you so much for replying! I struggled to make sense of what you wrote in regard to my first problem as I was not familiar with Script Parameters but I did some reading up and I think I've cracked it. Now I'm trying to understand your solution to my second problem... Thanks for your help. Sean Edit: Fenton, thanks for your reply, I hadn't seen your post when I replied above so I will take you up on your offer to look at the files. Any opportunity to be critiqued on my work so far would I'm sure make things easier down the road. MyDatabase

Hi all, I figured out my first issue but I'm still struggling with my second problem (plus a new one). I guess given the lack of responses I might not have been clear enough so I thought I would include some screenshots and review my problems: This is my 'Contacts' table showing details of people: This is my 'Companies' table showing company details and related 'Contacts' displaying in a portal: 1. My first problem is that when I click on the blue email symbol on the 'Companies' table (in the portal) it always loads an email with the address of the first person listed regardless of whether I click on the first, second, third or whichever listing in the portal. So in the example shown, if I click on the email link for 'Ron Manager' it persists in loading an email with Bob Fleming's address details. 2. My second problem is that on the 'Contacts' I have a checkbox which assigns a person as the primary or default contact for a particular company. When this box is checked I want that person to be listed first in the portal on the 'Companies' table. My specific problems with this are: a.) I'm struggling with calculations and scripts so I'm not sure which calculation recognizes whether a checkbox is 'checked' or not. b.) I'm not sure how to dictate the order of entries in a portal or even if it's possible. c.) When a checkbox is checked by the user how do I have any previously checked boxes on other 'Contacts' entries be unchecked if they are no longer going to be the primary contact. Hope that makes sense. I'm finding this pretty tough but I'm keen to learn so would appreciate some insight from you experts. Many thanks Sean

Anybody help a noob out? :)

I am making a Contacts database consisting of: 1. Contacts: People's names and contact details (just phone and email) plus the company they work for. 2. Companies: Address, phone, website and a portal showing people who work for this company (related to the 'Contacts' table). I'm trying to do two things but failing spectacularly. 1. On the 'Companies' table (with the portal) I have a button for people to add a new 'Contact'. It's just a script that goes to the 'Contacts' layout and makes a new record. However I want it to set the field on the 'Contacts' table to show the company name from which I clicked the 'Add Contact' button. Does that makes sense? 2. On the 'Companies' table (with the portal) I have a button next to each contact which opens the user's email client and pastes in the name and email address. However if there is more than one name in the portal it always copies and pastes the top name regardless and not the name you click next to. Thanks for any help offered. I realize these are probably ridiculously simple things but I'm still new at all this.

Hi, I'm trying to figure out how to have my field labels default to a larger size than they currently are. Shouldn't they match the default size for the text IN my fields?

Well I haven't really tried editing them. I'm just trying to understand what exactly the fields are doing. Thanks for your help.