adyf

Can you give an example of how to do this please?

I'm using the goto related record script step to access records in another file but I can't get them to sort. I have tried defining the sort I require in the define relationships dialogue box. I know I could define a sort as part of a script trigger (on layout enter) in the other file but I didn't want to do this or don't I have a choice? Another minor issue I've noticed is that I have had to select new window in the goto related records dialogue box to go to the other file otherwise nothing happens. Does anyone know the reason for this? Thanks in advance.

Thanks for the replies, I'll try these when I'm back at work.

Hi Lee, does this not return the file path of the database file itself? Or can I still work with this function by adding to it somehow?

Is there a Get () function to obtain the file path of an object that it is referenced in a container field?

Thanks for the explanation Bruce, I needed to look more carefully.

Thanks Fitch, just the job! I can't find this function though in the list of Get functions or within Filemaker help. Also interested in "isFrontTabPanel", this must be a built in command or something?

I have three tabs on a layout with a container field on each tab that has a linked MS word document within it. I'm trying to create a simple script that will open the linked MS word document on the active tab. Each tab has an object name assigned through the inspector. I thought an If [] statement using the Get (activelayoutobjectname) might work followed by Go to field with (select/perform) checked but it doesn't. I'm sure it should be something quite simple.

Thanks Laretta, I've no real issue by solving the problem with another table occurrence. I just fancied the idea of doing it by filtering the contents of the List function. A little personal challenge and adding another string to my bow so to speak. The more I use FM the more I realise there are multiple ways of doing things, although I don't suppose it's necessarily a good thing to get all fancy when something simpler and cleaner would suffice.

Sorry, it's a little more complicated than just a basic find I think. I was looking to pull contacts with no email address into a related memorandums file. As they have no email address they won't receive memos via email and will require the information by another means. It just act as a prompt for me to do this.

I'm still learning as far as calculations go, particularly calculations within calculations. The other day I wanted to get a list of people from a contacts file that don't have an email address. I could get a list of everybody but I couldn't filter out the ones without email addresses. Would you wrap a FilterValues calculation around the List function or vice versa or do something completely different? I managed to do it by establishing another relationship that did the filtering for me and then used the List function. Nothing wrong with this solution I feel other than having another table occurrence on the relationship graph just to accomplish this one thing. In this instance I would have preferred to have been able to create a calculation field that filters the List function. Could somebody give me an example of a calculation that would work please?

I think I was looking at this in too much detail. I was expecting some kind of calculation that automatically worked out how many characters fit in the field and then an appropriate automatic font resize. Never considered conditional formatting but your solution works, thank you. I'm struggling for room width ways, but yes I could have increased the field depth.

Is it possible to apply a calculation to a text field that will decrease the font size automatically should there be too much text to display on one line so that it fits? I could decrease the font size for the field in question across the piece but it happens very rarely and I'm pushed already for layout space with regard to increasing the field width.

The additional information you provided changes things. Could your structure be overly complicated? In that I mean do you need separate tables for different types of equipment, isn't equipment just equipment? Could you not just have one equipment table and then a field called Equipment Type and one called Equipment Cost and then set your summary report up as per David's suggestion?

Thanks for the link, I think something like this would work. I'm not sure I'm at the right skill level just now.

I have the following tables that manage the routes that Train Drivers have the competence to drive trains over: Train Drivers ->Competent Route Sections<-Route Sections Managing data this way is fine but do you get a much better overview if this data can be seen geographically on a map. The route gaps can be seen easily where it would be logical for a Train Driver to learn next etc. We do have geographical maps to show this but they are currently managed in word documents, changing a line on a route map from default black to red when a Train Driver is competent on that route. Works ok, but there's the possibility of sync issues using two different systems. I've been wondering if it would be viable to do this in FM, taking into account how difficult and time consuming it would be to set up. How would I do this? I was thinking pre-drawn route section lines in a container field in the Route Sections table, with these container fields overlaying the geographical map layout. I'm sure this can be done somehow, if a Train Driver isn't competent on any Routes Sections then the map lines are black (default), the Route Sections the Train Driver is competent on should be red. Therefore when records are added or deleted from the Competent Route Sections table the Train Drivers geographical route map redraws automatically. I love the idea but I'm unsure how to tackle it and the difficulty involved. Any thoughts would be greatly appreciated.

Is there currently a way of extending the scope of the 'My Content' feature to search for posts older than a year? Hope it's ok to post this in this sub forum.

Hardly exhaustive testing, but I've just opened up an *fp7 file in Windows 8 successfully with FMP11.

I've set webviewer up to display pages that require an SVG viewer to display images within the web pages. The images are blank within webviewer but display perfectly in Internet Explorer. Is there anything that can be done or do I have to abandon this idea? Thanks in advance.

Hi Jeremy, thanks for your reply.

I have set a button up on a field to go to object and specified "photos" in my case but it doesn't work. I have named a field on the tab I want to go to "photos" in the inspector. Don't know if this is relevant but where I want to go to/from are on different layouts and tables. Am I missing something simple?

I have a relationship set up between two files (not tables within the same file). I'm then using a GTRR script to go to related records that are sorted as part of the relationship criteria. When I run the script it doesn't go to the other file, however if I manually go to the other file the related records are displayed but not sorted. As part of the GTRR step I checked 'new window' and the script works perfectly. Does anyone know the reason for this please?

This worked, thank you very much. Comment, not sure what more I could say, I just wanted to go from one layout to another and perform a find all in one script.

Could I have a bit more info on how to do this please? I can set a variable as part of the script but then what, how do I insert it into the field in find mode?

Sorry, I wasn't clear enough on the first script step: Go to layout (unrelated table) I was already doing this. I'll try this, thank you.