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
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
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
3 freelancers are bidding on average $207 for this job
Hello. I have experience of FileMaker for 3+ years. I have understood your Requirement and I can work on that. We can have combined efforts to make your solution powerful.