[FX.php List] Repeating Fields and MySQL

[Jon Montgomery]

On 10/14/06 9:57 AM, "Gjermund Gusland Thorsen" <ggt667 at gmail.com> wrote:

> Go relational, skip the repeating fields, please, for you own sake.
> 
> On 10/12/06, Jon Montgomery <vicepresident at onecliq.net> wrote:
>> Hi,
>>     A project I have been working with in FileMaker since version 4 is
>> needing to go to the web.  Well I can get FX.PHP to work for the data entry
>> by school music people fine.  But there are DB structure problems that have
>> happened when upgrading to the newer versions of FileMaker.  Going from the
>> Flat file to the fully relational part has not happened.
>>     The university people that are working on web based project side of this
>> data base are not FileMaker people and that makes them not FX.PHP people
>> either.  They think the need is to go with MySQL.  I have read that many of
>> you use both. ( I am a music instructor by trade and a FileMaker Data Base
>> person on the side because no one else would do it and nothing commercial
>> exists.
>>     The data base is pretty complex in it's functions for administration and
>> I have been able to make it do a lot of things.  (the problem is that it
>> might not have been the "best practice" in order to make it work, it just
>> works.)  Now that we have the university involved and the goal is to make it
>> all web based, we have run into many problems.
>> 
>>     Here is the dilemma that I think one or more of you can solve and prove
>> to the university what a fine program FileMaker is and that it CAN do all
>> that it needs to and be web based.
>>     We need to collect data in MySQL and import it into FileMaker to get us
>> by the first phase of online data collection.  The FileMaker program has two
>> repeating fields, first name (with 20 repetitions) and last name (with 20
>> repetitions)
>>     Main question, how do we turn the MySQL data for first and last names
>> and import it into FileMaker's Repeating fields?
>> 
>>     Your help will be much appreciated.
>> 
>> Jon Montgomery
>> 
>> --
>> Jon Montgomery
>> Home phone: 618.542.2287
>> School phone: 618.542.2646 ext, 1133
>> Home email: vicepresident at onecliq.net
>> School email: jwmontgomery at dqud300.perry.k12.il.us
>> 
>> 
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>> 
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

Thank you !  for some reason, I thought that might be the answer.

Jon