Hi

Do you suggest to rebuild a new database from scratch in FM8 or Import from
FM6 ??

After this I may have a problem ?! I use the FM Unique ID number to create
relationship between former database, when creating a new database in FM8
from scratch and using to link between tables.... I will some day hit the
same numbers twice ?!

My field was a calculation Get(currentRecordID) so I can't import into that
field unless a switch to a NumberField and then all my relation from the
past database will work, but not the new one, I will double some number ?!?!

Any Ideas ??

I thing of this...... Start from Scratch, import data, set my RecordID field
to a number, link tables, create a script to get the new record ID paste
into my relation fields and that's it !

I this good or you have better ideas ?

Thank you

JF

In article <AImch.68376$yw5.2119460 (AT) wagner (DOT) videotron.net>,
"JF" <bizouman_takethisout (AT) hotmail (DOT) com> wrote:

If you batch convert, you end up with a replica of the FM6 database in
FM8. It will work like the FM6 database, with all relationships intact.
The data tables will be separate files, as they are in FM6. The file
references and relationships to replicate the functionality of the FM6
database will all be automatically established in FM8.

You will need to do this anyway in order to get the database in a form
that FM8 can import, even if you decide to build a new FM8 database from
scratch.

If you build a FM8 database from scratch, then you will need to import
the data from the converted database that you made by batch conversion
from FM6 to FM8. When you import the data, you should import the values
of the key fields that are used in the relationships. Then you should
update that next serial value for the primary key fields to be one more
than the largest value in the imported data. That way the relationships
will be intact for the existing data, and new records will automatically
get higher serial numbers.

--
For email, change <fake> to <earthlink>
Bill Collins

Thank you

I decide to start all over in FM8, I convert the file, print some info and
copy some layout.
But your serial number thing, I think, won'y work, because by putting +1 to
largest number and go on..... some day if that number is reach by the new
data base....

I think I will create a script to import the new UniqueID and make that
links table after.....

The other main problem, I do this for my own compagnie, and must of the time
from Home, and while I'm working on this project, the office still add data
in the old FM6 solution....

This will be my Cold Canadian Winter project !! I'm not that luck to be like
Helpfull Harry and have a boat in the Carabbean!! :O) LOL ! Nice picture by
the way.

JF


"Bill" <bbcollins (AT) fake (DOT) net> a écrit dans le message de news:
bbcollins-39BE64.09352003122006 (AT)....earthlink.net...

Setting the next value of the serial number to 1 mure than the highest
number in the imported records, you do in the NEW database. Then you do
any new data entry in the NEW database. So there is no conflict.

Bill

In article <aeDch.29784$Cu4.262092 (AT) wagner (DOT) videotron.net>,
"JF" <bizouman_takethisout (AT) hotmail (DOT) com> wrote:

--
For email, change <fake> to <earthlink>
Bill Collins