I have a system of Filemaker Pro files of Quotes, Sales Orders and Invoices. These files have been in use since Filemaker 2. Once a quote is created the separate items of the quote are entered into repeating fields. When customer a purchased quote 1021. The quote has several fields (Item #, Unit Cost, Unit Retail, Item, Ext Cost, etc) that are all 18 itereations of a repeating field. When I go from Quote to the Sales order file I enter the quote number and all of the items come from the quote to the sales order.

Problem:

However when I tried to repeat this with a new product file for the quotations file, only the first field is filled in. I cannot go to relational without a major overhaul of the filemaker files, which in my case is just not practical. I know that this can be done but for some reason I can just not duplicate the action. Any help would be greatly appreciated.

Could it be that you have a duplicate product ID, and the original record has blank fields? I.e., it's doing the lookup, but the fields it's looking up are blank.

Ok I have an amedment to the orignial post. I am able to get all of the fields pulled over it the item # in quotes is not a repeating field. I have uploaded a working example and a non working example. I need a way that I can have multiple items on a single quote and I am not sure how to do this at this point.

fmpro.zip

I looked at the files.

1. What are you looking for? What is supposed to happen? Your complaint is self-contradicting. How do you expect to have multi-line product descriptions and multiple items on an invoice?

2. The additional lines of product description do not belong in repeating fields, they belong in a single "Extended Description" field.