is there a better way to do this?

[sunkissedeyes]

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.

[sunkissedeyes]

this was my previous post if you are curious:

http://fmforums.com/forum/showtopic.php?tid/180938/

[Lee Smith]

[color:red]Why the double post?

[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.

[LaRetta]

Hi sunkissedeyes,

Two things will happen here ... 1) Someone may read your other post and still respond and 2) Anyone attempting to help you on this post will have to read the other post to gather information on what has already been attempted. And, if someone responds on the other post as well, then it can get quite confusing and segmented for everyone.

No biggie ... but if you don't get satisfactory answer on a post, you can always respond on it again, asking for additional assistance so it again pops to everyone's attention. It doesn't matter WHERE you post because most of us read all posts anyway. But segmented posts are difficult to follow.

LaRetta

[Lee Smith]

Hi sunkissedeyes,

LaRetta has pointed out the problems with duplicate post, or splinter Topics.

I'll add that it isn't always easy to determine that you are doing this. Especially, when you are new, and don't understand that a Topic will often change direction during the process of solving the problem. The easiest way to determine if it is a continuation, or a New Topic is to look your new question from the Forum side of it. In other words, if you were to be asked this question, would the information in the existing topic help you understand, the problem? Is this additional information you have provided in order to make yourself clearer? Is this a follow up question to the question asked by someone in the existing post? Is this a new approach to the same question? Is this an also problem that is tied to the original question.

Anyway, I think you got the idea of what I'm trying to say.

HTH

Lee

[AnFrusch@pepp]

Hallo all,

we have 2 filemaker server working together in LAN.

First server host 'internal' databases used by the employees, the other one host a db that is published on the web.

The internal db has various reference to open the web files and write or read them so that they can by frequently synchronized.

Sometimes the web server need to be restarted, we close the databases and the internal files loose the reference.

I usually restart filemaker application and the connection to the web server is automatically re-established but I'm wondering if there is another method to 'reload' the reference.

Note that is not just a re-open file instruction because - even if I open a file previuosly closed - the application still don't recognize it and filed on the layout are still marked as "field missing".

I tried to reopen files via script, I tried to 'close' it and then open it but nothing seems to work properly.

Any idea?