thorgil

Thanks... Helped a lot /T

Hi everyone! I want to copy (in a script) all records (0 - many) from a database (called main) where a specific field ("id") matches a number (say 7) to a different database (called temp). The temp database is empty but with fields defined. How? Is there another way than doin it record by record? /Tobias

Yes, it's numeric values. But how do I get the last ValueList Item? /T

Thanks for the help.... Though as always... it resulted in more questions... Patterncount( calcfield, "

A value list in other file create I will. Queue I thank.

Well, I dunno. Thats why I am asking. Something like: getfielddata(dbase,field) (I know thats not the name of the function but thats what I want to do.) The reason is: I don't store any data in my "main" file. I have a current_id field in the main file and the relations to other files depend on this. I want to change the value of this (by scripts) but only to values that exist in a field(all rows) of another file. Problem is I can't find a way to check if a value exists in the other file. I want to do this without changing the other file at all. ( I come from SQL so my logic is not really FM logic) /T

I'm lost in the help files...can't find the right function (or method)... How do I do i get All the values of a field from an external file without a relationship?. I wanna do stuff like finding the next value in external_field that is bigger than value x. /Tobias

ok, thanx... Brians style seems to work for me....

Con't find the thread Ugo. Can you post a link? /T

Thanks

Is it possible to execute a script upon content changes in a field?

Background info. I have four levels of grouping. level 1 and level 4 are always present. level 2 and 3 are sometimes present. data looks something like this (all in one table-can't change it..."supernormalized sort of") TABLE ( UBBcode code doesn't work for me excuse the ".'s") id.....level...parent_id....data 1......1.........0..................Q group 2......1.........0..................A and B group 3......2.........2..................A subgroup 4......3.........3..................asdf subsubgroup 5......2.........2..................B subgroup 93....4.........1..................qwerty 94....4.........4..................asdf1 95....4.........4..................asdf2 The given value is the "parent" of a level four record and i want rows looking like this (depending on level 4 id's): Level_1..............Level_2.........Level_3..........Level_4 Q group..............None.............None..............qwerty A & B group.......A group.........asdf group.....asdf1 A & B group.......A group.........asdf group.....asdf2 I can do with just the id's also... But is this possible in fmp? I was thinking about using scripts (i guess i have to...) but how do i execute a script when a calculated value (level 4 id's) is changed? /Tobias, fm newbie Ps: Does anyone understand what i'm asking? S

From a complete fm newbie (for like 2 hours) with a problem. I have 3 fm-files with data (reference, publication, author) (I have more but solving this would solve the rest) structure reference: publication_id (number) author_id (number) structure publication: id (number) name (text) structure author: id (number) name (text) In reference I want a pop-up list of the authors name. When i pick a value from that list I want author_id (in reference) to change to the corresponding value defined in author. I also want it to work the other way around. If I change the value of author_id I want the selected value in the pop-up list to change to the value specified in author. Same thing with publication but I guess i do that the same way... The layouts of the database tables are fixed. (fm is used as an editing tool for a sql database). Is it possible? (I can't get it to work) How do I do it? This might be the simpliest thing in the word but I am under time preassure so I don't have the time to dig into the manuals (or this forum) to search the answer myself). I also want a add author name button in reference but i think i can figure that out.. Any answers (or pointers) whould make me very happy. /Tobias, Sweden.