marcsi

Thanks Laretta, I shall try this out first thing! Very much appreciated! : Marcsi

Hi Laretta thanks very much for the quick response! I'll give this a go as soon as I get to work. Just one question: when you say be sure to point the key fields properly...do you mean the fields that are foreign keys or primary keys should be linked to the appropriate tables or did you mean something else? Many thanks again, Marcsi

Hi John, thanks very much for the response. How do I repoint a table? I couldn't find an option for this yet. many thanks again, Mariann

John thanks very much for the response, I shall do that at least till the next version of fm (fingers crossed).

Hi All, We're in the process of migrating our fm tables to mysql, however we'll have to carry on using fm for a while and so we need to link the external tables back to fm. I had a table called membership_types in fm which I duly moved to mysql with all it's data and then linked it in the fm database. However one of my value lists used data from this membership_types table (when it was still in fm) and when I tried to do the same with the linked mysql membership_types table fm wouldn't let me (external tables are greyed out when trying to select a table for the value list). Is there some sort of workaround so that value lists could display data from external data sources? Many thanks in advance. Marcsi

Hi All, Many apologies in advance, this is a bit long winded. I work for a charity and we're in the process of moving fm data to mysql but we'll still need to carry on using fm for calculations, mailouts, etc. So for example we had a table called 'memberships' in fm, I created a table with the same name in mysql and exported all the data to it. I then deleted the memberships table in fm and linked the external memberships table into fm via ODBC. Naturally as soon as I deleted the fm memberships table all scripts and layout objects also lost the reference to it and linking the mysql memberships table didn't rectify this problem either. I managed to solve the problem with the scripts by reimporting them from a backup fm database, but I don't know how to solve the same problem with the layout objects. Is there a way to delete or rename tables/fields in fm without affecting the scripts and objects referring to them? Many thanks in advance, I would really appreciate any help. We have a lot of tables to migrate this way! Marcsi