Re: FileMaker Pro

2003-07-12 Thread David Shugarts
FM is no problem. You can output from it to a tab-delimited file and then INSERT it into a mySQL DB. Or, a number of mySQL clients, including myPHPAdmin, allow you to import a text file, such as a tabbed file (or CSV, etc.). You must first set up your mySQL datatbase and be sure that the field type

Possible solution to a simple newbie problem of JOINs

2003-07-01 Thread David Shugarts
My newbie problem is solved and it may help other newbies if I share it. The idea is to take two or more tables and combine their data into one table that you can query. Each of the source tables may only have one or two columns of overlap. You want records (rows) that do not fill in data in unu