New to this scene and need help to write a script on getting data from several tables on to one final table. Its several bill of quants for various jobs that I need to get on a final BOQ table.
Your help would be appreciated.
Depending on whether you want to create a report, or if you actually need new records created, a Virtual List can be of great utility here. (Google the term "FileMaker Virtual List" for several good resources.)
Other than that, if you're proficient with SQL, you can use ExecuteSQL to assemble an "array" of values for the final table. Other alternatives include importing from those several tables or building lists of values in variables and then creating the records from those.
it sounds like you're creating a flat file from related tables. What happens after you get the data into the file?
Either send via email as a report or send to SQL server.
How are you sending it to SQL Server?
back working on it again. I have attached some screenshots to help. I have filtered the records out that have quantities and now need to copy the fields in the TM BOQ table ( Top screenshot ) into the BOQ table ( Bottom screenshot ). your help would be appreciated.
I'm not 100% sure, but it looks like you have a one-for-one correspondence between the source table and the destination table. Won't an Import do the trick?
Retrieving data ...