sunkissedeyes

i didn't think of it as a double post. i thought of it warranted a different thread. my apologies if it should have been in the same thread.

this was my previous post if you are curious: http://fmforums.com/forum/showtopic.php?tid/180938/

i have to update dates in a few related tables. as per my previous post i could not get it to work automatically via a calculation tied to a field. so i'm pursuing a script option. this works, but seems to not be very elegant. Set Field [ AA::DateOut; CC::DateAct ] Set Field [ AA::DateDead; CC::DateDue ] Go to Related Record [ From table: “BB”; Using layout: “LIST” (BB) ] [ Show only related records ] Loop If [ BB::Type = "swap" ] Set Field [ BB::DateEnd; CC::DateDue ] Set Field [ BB::DateBegin; CC::DateAct ] Exit Loop If [ BB::TaskTypeName = "swap" ] Else Go to Record/Request/Page [ Next; Exit after last ] End If End Loop Go to Layout [ layout ] is there a better way? i tried a "find" instead of the loop, but it restored prior to the search and searches all my records rather than just the related ones. thanks.

not sure what you mean... the link doesn't work for me. which post are you referring to?

thanks for the ideas... the fields involved are all specified as 'date'. i tried lookup but it didn't work either. i did make a script and attached it to a button and it worked. but i'd prefer the fields to be update without any user intervention.

i just switched out a use of InsertCalculatedResult to SetField and it certainly does seem nicer.

i tried this in a script and it worked for me: Insert Calculated Result [select; yourfield; "0" & (GetAsText ( yourfield ))] i made a button and attached the script to it. each time i click it it adds a preceeding zero. you could make it loop through your records to replace all the fields. there may be a better way. the field is text however.

i have a calculation that is working fine when i create the record. but when i change the data (a date) the the other field which has a GetAsDate function as the calculation. NOT WORKING [table 1] date_1 [table 2] date_A calc (get date from table 1 date_1 field) the calculation is not stored. if i put the field in the same table it works, so it seems like it maight be a relationship issue. the tables are linked via their Job# being the same which i verified as such. when i make a similar field in table 1 it works, but that's not so helpful. WORKS [table 1] date_1 [table 1] date_2 calc (get date_1 from table 1) i feel like i must be missing something very simple.

however, it seems recover made 378 extra fields in the troubled table...and bizarre behavior still exits but is sporadic. i think i'll need to export and reimport as per the technotes.

it may have a consistency check, but in my case we had corrupted records...blank but impossible to delete...and appearing on reports and in related records (somehow linked to an existing parent record). it seems a File -> "Recover..." may do the trick. i had tried that last week but likely was not patient enough. it seemed to hang on my corrupt table...but today it made it through!

yeah i knew the shutdown was a bad idea but the tech people insisted. the display was unresponsive and it fixed that! i'll check out those knowledgebase articles. thanks.

i believe when the server was shutdown [by pressing+holding the the front button on the macintosh server] the database became corrupt. i'm hoping i'm wrong. the records still appear, and can be edited, although filemaker claims there are none in the table in the "define database" menu item. one user is having issues where an extra blank record is created in addition to the ones that are supposed to be created via the script. no others are having those issues. when i investigate a copy of the database the automatically (by script) created records in that table appear but disappear and show an empty portal area 'placeholder' (if that makes sense). these empty placeholders can't be deleted. and appear to be related to the parent but can not be deleted, even when viewing the data in that table directly (i.e. not through a portal). but no users are experiencing this. any thoughts? i figure i have to work off a backup and recreate (or import) the data that was created since then. but maybe someone has some insight. thank you.