Not really (shifted gears). If I could write sql, I could do an Insert query from the original file into my relational tables, one at a time, with multiple fields per record. It would be a lot simpler than your option.
However, from what I have gathered so far, I can't use sql within Filemaker on Filemaker files, unless I use ODBC. And I do see that all of this would be in scripts. Make sense? Thanks! Ron -----Original Message----- From: FileMaker Pro Discussions [mailto:[EMAIL PROTECTED] On Behalf Of Steve B. Gerow Sent: Thursday, July 05, 2007 10:49 AM To: [email protected] Subject: Re: File Import Ron, Don't know what you mean by this. Please amplify. FMP is not SQL. You seem to have shifted gears from your original file conversion question. -- Steve Steve B. Gerow FileMaker 8/7 Certified Developer President Abrazos Data Consulting, Inc. Dependable Database Development Pasadena California www.abrazosdata.com Member FileMaker Bus. Alliance > > Can I do an Insert query on the original file into the new relational file? > Then I can insert certain constants, new field contents etc. > Using SQL seems to require an ODBC table for the source...
