Hello to all, I hope someone can help me out with this problem, I have a 60 File database and a few months ago one of does files started with some problems: 1- it Started loosing data and 2- If I try to delete a field FileMaker Crashes.
I performed a Recover option to this file but with NO results, then I called FileMaker Support for some advice or to send in my file, but they replay that this problem is NOT possible to be repaired, They suggested to duplicate the file with a new one by copying all Fields, Relationships, layouts and scripts. I started with this a few days ago and now I am importing all Scripts into my new database, everything was working fine until this step, when opening one of the scripts I realized that all fields, Relationships and perform script steps were all missing, then I remember that FileMaker works NOT with the Name but with a internal ID, its obvious that I will not be capable of creating all in the exact ID order they had, so I started fixing all my scripts to work again, but then it came to my mind that if all Fields and Scripts have a diferent ID it will also ruin all relationships, valuelists, formulas and any link to this file from all the other 59 files I have.
So my question is, Is there out there someone capable of manipulating the Internal ID to rearrange them like my original file ? Is there any other solution to this problem ?
I hope someone out there can help!
Thank you for your time!!
Brian Donovan
You could try viewing the fields sorted by creation order and recreating them that way - had to do that myself a few months back for the same reason.
Have a Great day! pete ________________________________________________________________________
: Hello to all, I hope someone can help me out with this problem,
: I have a 60 File database and a few months ago one of does
: files started with some problems: 1- it Started loosing data
: and 2- If I try to delete a field FileMaker Crashes.
: I performed a Recover option to this file but with NO results,
: then I called FileMaker Support for some advice or to send in
: my file, but they replay that this problem is NOT possible to
: be repaired, They suggested to duplicate the file with a new
: one by copying all Fields, Relationships, layouts and scripts.
: I started with this a few days ago and now I am importing all
: Scripts into my new database, everything was working fine
: until this step, when opening one of the scripts I realized
: that all fields, Relationships and perform script steps were
: all missing, then I remember that FileMaker works NOT with the
: Name but with a internal ID, its obvious that I will not be
: capable of creating all in the exact ID order they had, so I
: started fixing all my scripts to work again, but then it came
: to my mind that if all Fields and Scripts have a diferent ID
: it will also ruin all relationships, valuelists, formulas and
: any link to this file from all the other 59 files I have.
: So my question is, Is there out there someone capable of
: manipulating the Internal ID to rearrange them like my
: original file ? Is there any other solution to this problem ?
: I hope someone out there can help!
: Thank you for your time!!
: Brian Donovan