i created a database then i switched to table view and have set so that only name fields appear in table view , i want to know how to go to the related record in form view when i click on a name in table view ...

Every time I open this one database, it asks me if I want to use the system settings or the file settings. It doesn't seem to matter which I choose, the database works properly. But how do I get it to stop asking me to choose when the file is opening? ...

Actually, I wasn't entirely correct: you CAN change the field's name and, as long as (a) = (b) = (c), it will keep working (except the custom message will not reflect the change). ...

In Layout mode, double-click the body part and select "Page break after every 1 occurrence". ...

thanks, I am glad there isn't (hopefully) a severe problem. ...

By "able to use simple authentication" I meant that it sounded like your server was configured to allow simple authentication. Do you know if this is the case? Could you check with your IT people and see if simple authentication is allowed for connection to their servers ......

Future features, probably. ...

Quote: One of the staff members are duplicating student records for class schedules. Boy, that data model sounds wrong! So does the 120 databases on the FMS. Really, without a copy of the file (clone) or a shot of the script and Relationship graph, we're just guessi ......

I have found an acceptable solution that will work in some of the places I use the drop-down list. The field used in the value list is now an inserted calculation of the original text field with an extra twenty or thirty spaces added to the end. The problem being I re ......

Not sure what you mean by "It sounds like you are able to use simple authentication right now." If I try connecting to the city government IMAP sever with SSL off, the plugin errors out, and the EmailLastError function returns the "Can't load NTLM authenticator" error messa ......

There's a better way. Your "Add Note" button should capture the JobID and put it in the JobNotes:JobID. Like this, in pseudocode: Set variable $JobID Jobs:JobID New Window Go to layout Notes New Record Set Field Notes:JobID to $JobID Resize window Pause Close Win ......

I totally forgot that I had posted this question. Sticking a bunch of new images in the database doesn't present any problems. It's only the old images that made up the DB. Very odd. And, like I said, 4 previous versions of FM displayed it just fine. Only FM11 has a prob ......

Thank you very much for your help, does exactly what i needed. ...

You do not need to use SSL in order to do the simple authentication. I was just making a recommendation. It sounds like you are able to use simple authentication right now. Your NTLM and simple authentication connections are probably different ports. Are you using the s ......

Hi Jesse, Thanks for your response. On WinXP, I pasted in your code but had to add some to get it to partially work (below). It still throws an error but won't list it, and the Text Result is: "Executed shell command: [D, I, R]" It does not seem to actually be running th ......

Right ( "00000" & yourField; 5 ) ...

We just recently imported all data from our old system into filemaker and have found an issue. Our old system stored the zip code as a number but displayed it as text. So the zip code would show up as 00802, but was stored as 802. Now that everything is in filemaker, ......

Hi folx I have a file invoices with n invoice line, each being max 3 lines long. How can I figure out how many pages I will need, and how can I manage this? As far as I understand, printing will be from a layout of the invoice lines. But what else? Thank you for ......

Hi TDB, and welcome to the Forum, I think it will be difficult to find an off the shelf solution. I did a quick search yesterday and couldn't find one, but held off replying in case someone else knew of one. FileMaker Pro 5 is now 11 years old, and those older solutions ......

I just discovered that I can customize my toolbar in FM11. It's been a great discovery! As I was playing around in the customize window, I noticed that the toolbar screen has four buttons - New, Rename, Delete, Reset. Does this mean I can create new toolbars? The butt ......

I have a database to track job numbers. In a layout I have each specific job with a portal that shows the notes I have made for that job (notes are from job_notes table). I have a button "add_note" that has a script that opens up a new window in add mode to add a new note. ......

That's dependent on your layout design. Make it large enough to *display* one record per page. ...

Regarding the value of mentioning other users of a technique, this is in fact directly relevant, and done in consideration of the person who has come here with questions. When considering learning something new, there are several things to think about. These things incl ......

I recently upgraded from 8.5 to version 11. I like most of the improvements, but I have found that the drop-down list functions differently then before. Before, the drop-down "window" would resize to fit the displayed field. Now, the "window" only displays a portion ......

That's not going to work either; as a policy matter, the product requisition emails can't be forwarded to a server outside the district/metro government. So basically, there's no chance that the plugin will be updated to work with NTLM? If that's the case, it's essential ......

The script would look like Show Custom Dialog [ Title: "New Record"; Message: "Create A new Record"; Buttons: “Yes”, “No” ] If [ Get ( LastMessageChoice ) =1 ] New Record/Request End If HTH Lee ...

Done. ...

Man you made my day! So it's much easier than we thought, I can end this day of work in time, my wife will be happy and who knows what happens next I think it will come down to something like ValueCount( FilterValues( $StoredNIC , $CurrentNIC)) > 0 and ValueCount( Fil ......

You can't work the email plugin with the NTLM authentication turned on, but if you have another email server you can use, such as gmail, you could set up your exchange server to forward mail to your other mail server which you would be able to download from to using the Ema ......

Thanks, Comment and Charlie. As you may have noticed from my attached picture, I did not have a header; rather, I had a Sub-summary - body - Sub-summary. Before I tried either of your suggestions, I thought I had a moment of insight, so I added a Title Header without anyt ......

Unfortunately, the city email administrator cannot turn off NTLM authentication, or turn on SSL authentication, because either one would disrupt all the other IMAP users. So we're pretty much stuck. Is there anything else that can be done with this? ...

IWP messes with pngs and seems to have trouble with alpha channels (transparency) in images. Try using jpegs. (.jpg) If they will be used as part of the layout, try not to make buttons out of them. Again, IWP seems to run shy of useful with images as buttons. Make a transpa ......

FM10/11 Adv OS X 10.6.4 I need to be able to archive individual records and (on occasion) groups of records from more than 30 tables in a file that has been in use now for 5+ years. I have read the threads on this forum and others on the subject of “archiving records ......

Thx a lot. ...

Sorry for the length in replying, but other matters took precedence. The script increment number works like a charm but I get error when trying to move the value back to the record that was live when button clicked to increment. Debugging the script show the increment and u ......

I replied privately to this, here is the PHP code to access our test server if anybody else is trying to do this: Code:   <?php $soap = new SoapClient('http://wpeoffice.360works.com/websvcmgr.php?wsdl&Service=ExampleService'); $lookup =&n ......

Hi supernatural, currently Scribe cannot be used to insert repeating data, only single values. ...

Nicolaus Busch Said: but doesn't the NIC depend on the network connection used? Nope. The NIC (or MAC) is a property of the networking hardware you have installed on the computer. The MAC is assigned to the hardware at the factory. (There are some networking compo ......

Thanks for the input, but doesn't the NIC depend on the network connection used? As I understood this so far the NIC is not a property of the system but of th network adapter, so that a computer will return a different NIC when connected via WLAN, LAN or whatever. ...

Is there a way to print one record per page, or do you have to print each record individually? Thank you, Fed ...

Somehow the character encoding is getting messed up and you're getting invisible characters in the script. Please send me a direct message with your email address and I'll send you a copy of a FileMaker file with the script. ...

Hi Jesse Thanks for following up this issue. I hope you won't mind early feedback, but tried this code with the Shell script I want to have work. Sorry for the long file paths: cupsfilter /Volumes/Macintosh\ HD/Users/pracau/Documents/SolMan_System/Trainer_Re sources ......

True. In my (cumbersome) method, I was able to change field names however I wanted to. I also instantly saw which filter a value list belonged to based on its name. But you are saving a lot of code with your approach. These Filters are a lot of work to set-up anyway, so ......

Just keep in mind that this method has a flaw: if you change the field's name, you must also change: (a) the script parameter; (b) the value list's name; (c) the object name of the filter field. (a) could be dealt with dynamically, but I don't see a good solution fo ......

Wow, that's amazing - so simple. You always do amaze me with your suggestions, comment. You really do. Thank you!! I hope I didn't keep you too long, Michael ...

See how this works for you: ...

Excellent point, I could use the field names for value list names. That would simplify everything a lot. ...

If the value list is empty, they cannot choose from it anyway. In any case, my point is that your method requires checking a specific value list for each filter field - thus making the script general enough to cover all fields in all tables more difficult. Although you coul ......

I installed snow leopard and my filemaker 6 web companion will no longer work. Does anyone have a work around? ...

SOLUTION (maybe not elegant, but works) First define a variable with: Code:  "This filter can't be used because the field " &   Substitute (  GetLayoutObjectAttribute ("FilterSearch1  ......