Mif

I have 2 tables, One ESS SQL table and one Filemaker table related by "shop_product_item" ID. Table A is set to "allow creation of records...." in Table B (related throughout table occurrence shop_product_item15....) Table A. name = "shop_product_item" (SQL Ess connection) Field A1 - "is_published" (Auto enter calc - "Case (shop_product_item::in_stock = 0 and shop_product_item15_ShopProductItem_ID::z_unpublishAtZero = 1;0;1)" Field A2 - "in_stock" Table B. name = "ShopProductItem" (Filemaker table) Field B1 - "z_unpublishAtZero Problem - when SQL Table A > Field 2 "in_stock", changes to zero, Field A1 -"is_published", doesn't change to "0" If I change "A2" (in_stock) to "0" manually, "A1" changes to "0" How do I trigger the calculation in "A1" when SQL changes "A2" to zero?

I can't seem to get a horizontal line separating repeating fields, to show up using IWP. Works fine from FM client but not from web view. Any thoughts as to why? I've tried different thicknesses, colours, browsers and I am using the classic theme. Thanks

It only seems to work if you want to use it with one field, and only if that field is in the tab order. By the way, I tried the "Go To Object" with "Get Script Parameter", and yes it goes to that field, but still can't get that cursor flashing in the field. It just highlights the field border.

I can see how my question looks a little confusing. Let me give it another try. I have two fields on a layout, FirstName and LastName I want to be able to click in either of the two fields, invoke a find and end up in find mode with the cursor inserted and flashing in the field I clicked in. (The whole problem seems to be getting the cursor to remain in the field I selected. If it is the only field in the tab order, it works fine. If both fields are in the tab order, the cursor flashes in the the 1st field in the tab order. If none of them are in the tab order, neither gets a flashing cursor.) (My original question was around trying to grab the field name as a variable or through script parameter and then scripting a "Go to field" to get the cursor inserted in the field I want.) Thanks

My goal is to have a generic script which enters find mode, goes to "x" field so I can keep my script population down. I am attempting to do this based on the script parameter for the button launching the script, but it seems that the "Specify" option only related to a repeating field. Am I on the right track or is there a smarter way? If I'm on the right track, what am I missing here?

I have since noticed that crashing is what has caused it for me as well. There must be a temp file somewhere that contains the data.

Anyone know where I might recover a bunch of handy calculations I have always had listed on the "Watch" tab of the data viewer? Any idea how they dissappeared? Thanks

Thankyou, that worked perfectly. Believe it or not, today I am experiencing the same thing from my MacbookPro - Is there a similar setting there?

FM 11 - 20 clients running off Server 11 and using Windows XP 2 - While in find mode, three of those clients can't see what they are typing until they click out of the field. This is only happening in FileMaker. No strange behaviour in any other programs. Windows administrator checked that everything is the same on machines with and without the problem. Measures taken: 1. Made sure hardware and Windows settings matched between machines 2. Made sure FM memory settings were the same. Because it looks like a refresh issue, I wondered if this had something to do with the way the client was communicating with FM server. Sorry if this post is in the wrong forum.

I am working on a solution with a very large relationship graph. The last 1/8 of the graph only shows the TOG connectors and none of it is editable. I have tried two things. 1. increased memory up to 256 - but no changes 2. accessed file remotely in 2 different ways. a/ VNC direct to client server (Mac Mini - 2G ram - fm Memory set to 256) b/ on macbook pro (4gig ram - FM memory set to 256k), via filemaker network In both cases, exact same result. At the breaking point, just one scroll arrow click downward and TOG's lose text and editablity. (see attachment) I also have gone through the entire graph and minimize all TOG's which should have freed up some memory but still same problem at same location. Any suggestions?

Thanks Comment, that worked fine. Another example of the "blinding flash of the obvious". Maybe I wasn't pausing after entering find mode, which made me think that it wasn't entering the field....hmm?

I've tried making the field a button as well as script triggering based on entry, keystroke and modify.

I find if I just use Enter Find Mode [] that the cursor isn't anywhere to be seen. What am I missing? I'd like the cursor to be flashing in any field I click on the screen.

My goal is to click in a field, and end up in find mode with the cursor in that field, type a request, and hit enter to perform the find. So far I have created this script launched by the field: Set Variable [$Fieldname; Value; (Get (ActiveFieldName))] Enter Find Mode [] Go to Field [] -"it is here I want it insert $Fieldname" What should I be doing?... Thanks in advance

I found the answer. This occurs when custom menus are activated, in which case I have to make sure I am in layout mode before entering the relationship graph.

Yes, two or more TO's are selected in this case. Along with all the arrange buttons being grayed out, the "Select related tables 1-away" and "Select tables with same source table" are also gray, yet the hotkeys for both work fine. Here are other things I have checked; - I updated from FM 11 OV.1 to FM 11 OV.2 - still same problem - 3 files opened. One remote file works fine. The other remote file and a local file, both have the problem. - I am using full access privileges on all 3 files

Anyone know why the four arrange icons in my relationship graph are grayed out?

Without using SuperContainer, are there some best practices listed somewhere that ensure the best performance when loading up a solution with images etc. In my case I was considering capturing a scanned version of a doc to keep as a reference against the key'd in version. One thought was to create a separate file and externally reference them. Also to make sure they are scanned in at screen resolution and in black & white. Am I on track?

Ok, thanks for the insight. Could you help with some more clarifiying questions within these steps. 1. In Graphics table, I will create a non-global container called LogoSource. a/ How do I "store" the logo. (I'm assuming insert as picture and uncheck the "store only a reference..." 2. Create another field in Graphics table called Logo, and make it a global field. 3. From the start up script, set the "Logo" field with the "LogoSource" field. b/ Is this just a "Set field" command or something else? 4. Then place that "Logo" field, from the graphics table, anywhere in the solution and because it is reset everytime someone opens a session, and it is a global, they will see the image. Thanks Again

Sorry for the ambiguity. Connection - FileMaker Network TCP/IP Relationship reference - Good question as to why I did it this way. Probably because this file has a sizeable number of TOG's in the relationship graph. I liked that it easier to find in the table list. Does this pose a problem? Server - There is a dedicated Mac Mini used exclusively to host this Filemaker solution, so we call it the server. I will refer to it as the host database. Explicitly set globals - Yes, this is what I thought I was doing. As I mentioned, the global field displays correctly from anywhere on the host file where this global field is referenced. Is there another way to explicitly set globals? In this case, I am just trying to display company logos across the solution as efficiently as possible in a multi-user environment, including TCP/IP access. Thanks

- Table A is Linked to Global Graphics Table through two constant keys. (calculation = "1"). - The Global Graphics Table has global container field called "ColourLogo". Inserted into it is a picture. (store only reference to the file is unchecked) - From a layout based on Table A the "ColourLogo" field is added. On the server, the image shows. From remote access, the image isn't there. Any ideas why I can't see it. (it is a tiff image. )

Hey, thanks, that worked perfectly!

I have a container field that I have linked a file to, selecting "store only a reference to the file". Is there a way to extract the filename that shows up in the container field?

Any idea why this could be. I did check the "Files and Permissions" under "Get Info" and made sure Read and Write were available to all. I just discovered that on this file (Contacts), Sharing is under the Filemaker menu, where on my clients Invoices file (and most other files), Sharing is under the file menu, yet they are both opened up in FM 10. The new question is why are they different? :

Try checking the line format options for the text field you are typing in. a/ From the "Format" menu select "Text" b/ click the "Paragraph" button (bottom left of floating window) c/ Check that "Line Spacing" below and/or above settings are "0". Chances are that below says "4.00"