CarlAndrew

You are a star - Thanks a lot ! Best Regards Andrew

Hi Comment Posting my file, hope this can help you see what I'm doing wrong Thanks for your help! Best Regards Andrew version3.zip

Hi Comment, Thanks for your answer, I've been away for a few days and not been able to read this great homepage I've followed your advice and done just this. The "GoToReleatedRecord" is ticket with the "Show only related records" option and the relation I've setup in "define Database" has one link of type '=' between both ID's in each layout. Still I get all records from the EventData layout. Is there any other way around this problem or should this work? Thanks for your help, Best Regards ANdrew

Hi, my DB is to be receiving XML data continuously (by importing a file). I'm struggling with how to do this. I can import one file - no trouble But how do I do this if I want to run FM7 and my DB and importing "the fly" while I'm working? Is this possible at all? I could shutdown FM7 and start-up every time I want to import but then I can't work on the DB while not importing... Can I have an import-script that runs every minute or polls a file for status? Best Regards Andrew Carruthers

Hi Comment, thanks for your help! Hope you can help me some more bucause I can't seem to make it work. What happens is that ALL the Event records turn up which is not what I want. Maybe I didn't explain the relations enough?! I have the same field-type; ID in Car layout and Event layout, but for one car record there can be more than one Event record. I have an "=" relation between the Car and Event layouts. Hope this input can help you in helping me Once again, thanks for your time and help! Kind Regards Andrew

Hi all FM Developers I'm trying to find al related records to a person but can't make it work. THis is the setup; I have Persons-records, each Person-record can have 1 or more Car-Records. So when I in a script find a person and then execute the script step "Go To Related Records[from Car layout, using Car Layout] I'm expecting ALL that persons cars. Instead FM7 displays ALL cars in the DB and not only those that are related to the person I've just found - why?! Can anyone please tell me what I'm doing wrong!? Kind Regards Andrew

Hi, I've come across this problem a few times and hope someone might have been down this track before me! This is what I'm trying to do; I have 3 layouts - "Person", "Car" and "Events". One "Car" record can have many "Events" reocrds. When I look at one "Events record" I would like to have a script that finds ALL "Events records" for the related "Car record". These "Events" records would have the same 1st field/value (ID) but other fields would have unique values. So I've made a script that does this (keep in mind that I'm a newbie at FM7 :-) Go To Layout [Events] Go To Field[select/Perform, Events::ID] PerformFind[] SortRecords[] But how do I specify the search criteria? I can't specify it in PerformFind that I want all records that have the same ID!? Don't know if there is simpler way to do this?! Kind Regards Andrew Carruthers

Hi Lee thanks for your time and help. Hope this can clarify things better; Established database contains the following fields in each record ID Number Description Weight Height Colour I'll be periodically importing the following data: ID Number Price Distributor Date I want the programme to identify the record which has the matching "ID Number" Once again - thanks for your help Lee! Best Regards Andrew

Hi Lee and thanks for your answer, Yes your where right about my question - it wasn't all that clear. This is what I want to do: I'm imoprting a record which has 4 fields, one being an ID. With this ID I want to search the rest of the DB, which has different types of records but have the same type of ID-field, these ID-fields are defined as TEXT in both types of records. I suppose that you could call the imported record an identification records or lookup record. Once I find the matching records I want to transfer some of the data in the imported record to the matching one. So, PERFORM FIND doesn't seem to help me. How would you solve a problem like this ? Thanks again for your help! Best Regards Andrew

Hi, I'm trying to find a record that has the same field in both records. The records have different fields (one is a search record. In the script "Perform Find" I can't see how to I'm to specify the both fields. Can this only be done with a loop over all records and make the find with an IF statement? Very greateful for any info on this subjet!! Kind Regards Andrew

Hi, I've got a DB for which the records have fields of IDs (text). I would like to create a file with such ID as a name - is this possible? Also, when the file is created I would like to open and close it with this ID, but in OPEN FILE script only have ADD/DEFINE file refs. Has anyone done this before? Many Thanks Kind Regards Andrew

Hi, this is probably a stuppid question, but I can get it to work. I've imported a record into a table whch has field called ID. With his ID i want to lookup a matching record with another_ID. So I thought that; If(ID=another_ID) blabla.. EndIf would do it. What am I doing wrong. I've looked in the online-help but the doc is not that clear. Greatful for any help Best Regards Andrew Carruthers

GREAT! That clarified alot - thanks! I can now import the data!!! Have looked for the book here in NZ via the et but cannot find it! Will try again tomorrow... Best Regards Andrew PS. sorry about your computer, hope it feels better in the morning

Hi Fenton, Many thanks for your response Fenton, sorry for not coming back earlier but I

Hi Fenton, thanks for your time and XML file! I'm currently trying to read all literature about FM7 but asking someone who know is obiously a lot faster I've tried it but don't know if I'm doing somethimg wrong. I try to import the file via FILE->"IMPORT RECORDS"->"XML DATA SOURCE" - FM7 returns with the answer "XSL:for-each... not valid". I've noticed that I don't have priviledges for the page ="http://www.w3.org/1999/XSL/Transform" version="1.0" and I can't reach http://www.filemaker.com/fmpxmlresult when I tried to download them to my machine! Am I doing something wrong? I don't have the users manual yet, but can you tell me where the imported data is stored in FM7? do you need to import the data into a record or is there a "internal record" for this? Hope you can help me on this - really greatful for your suggstions and time fenton! Kind regards Andrew