Folks,

I created a data base with multiple part number files related to the same project (D0, D1, D3, ...,S0, S1...CL0, CL1, CL3,...etc.) Each project could contain up to 50 different part numbers. But since I need to create the same number of working folders I would like to use our Dymo laser printer to print labels using the information keyed in our data base. So far, I created the layout for the Labels with <<Description:>> and <<Cat. No. Series:>>. How can I add the part number info if not all the field have the same name? Could I use a script to gather all part numbers related to the project and then print only the files that contain data and skip the blank fields? Please advise.

gpg

I don't know all the details of how you have this set up but one route you may want to consider:

Dump all the data into a temporary FMP file through an import script in that file. Break the data out into individual records as you need to have it print. Inside the script find and delete any blank records, incomplete records or records you otherwise don't want to print. Use the temp file to print, then delete all. This could all be done in the scripting.

Hope this helps,

Cael.

CaeL,

Thank you for the feedback that's what I want to accomplish, but since my knowledge on FMP is limited could you help me with the script?

gpg

I honestly don't think I have a good enough grasp on EXACTLY how you need to handle the data and what you need to extract. You can send me the files if you want and I'll have a look at them as time permits.

Cael.