Filemaker Pro Script Assistance

We print designs to different products and sell them online. I am using FMP to keep all the information about the individual items we print to and the many designs we can print to those items. from these separate PRODUCT and DESIGN databases I am trying to create a merged file to upload to the webstores. I don't need any of the export information stored .. just exported like a mailmerge. the DESIGN_CODE will match many records the PROD_CODE will match one. For the example in the database I shared in my last post: 1) the user is prompted for DESIGN_CODE and PROD_CODE 2) FM finds ALL the matching DESIGN_CODE records 3) for each DESIGN record being exported - an export field will be created that combines the text from the current PROD_DESC record from PRODUCTS and the text from the SINGLE record found based on the input in the DESIGN table. in basic old fashion programming logic: (obviously in just logic/concept form as I have not worked with FMP scripting and don't know the syntax yet) get user input DESIGN_CODE from tableDESIGN (will be many records) get user input PROD_CODE from tablePRODUCTS (will be one record) var NUM_OF_DESIGNRECORDS = number total PROD_CODE records matching while NUM_OF_DESIGNRECORDS > 0 do export export PRODUCT:PROD_CODE as field PROD_CODE export DESIGN:DESIGN_CODE as field DESIGN_CODE export DESIGN:DESIGN_SUBCODE as field DESIGN_SUBCODE export calculation of PRODUCT:PROD_DESC + " - " + DESIGN:DESIGN:DESC as field COMB_DESC (simply adding both product and design descriptions with a dash inbetween) export PRODUCT:PRICE as PRICE NUM_OF_DESIGNRECORDS = NUM_OF_DESIGNRECORDS - 1 end LOL I am sure the logic and loop above reveal that I am old school as I was a computer science major when FileMaker was first released in 1985 I am including an image to help visualize my request: in yellow: the records found based on user input of KRING for PRODUCT and FLWR for DESIGN in pink are the fields needed from the PRODUCT records found in red are the fields needed from multiple DESIGN records found