So you are looking for a summary report for an estimate that shows the items and the fabrics for each item, right?
I see two avanti items with different data in B. Why?
Looks like a standard join table problem and you don't have one.
You need more tables.
Products; Product_Estimate_lines; Fabrics.
In general when asking questions like this it is best to disclose more of the data structure up front.
I enclosed more complete information about the problem in the same post. If you can help that would be great.
I enclosed more complete information in the original post. Any help you can offer will be greatly appreciated,
I want to thank the Filemaker community for not offering a solution to this problem. It forced me to dig deeper and come up with a solution on my own. I guess I was just being lazy or was too tired to see the simplicity of the solution. It was a painful learning experience but it is one that I soon won't forget.