Hello,

We manufacture windows and are trying to make order entry system. We have a Glass Order that you put in the Quantity and the sizes and then we have would like to make a assembly list that shows all the components you need to make each size. We would like to be able for it to copy the sizes and Qty. into the assembly lists at a push of the button. Do you have any Ideas on how you would do this I would greatly appreciate it. Thanks Alot Jonathan

What I think you want is to be able to choose a type of window (Glass Order) from a drop down list and enter a qty ordered. Then have the Assembly List for that type of window updated to the correct quanities.

ie. If the Assembly List for a Type A 48" x 40" Window contained:

- 8 9/16" C screws

- 2 20" x 20" panes of glass

- 1 40" x 48" weather strip

Then if a customer ordered 3 Type A 48" x 40" windows the order would print out

3 Type A 48" x 40" Windows

• 24 9/16" C screws
  
• 6 20" x 20" panes of glass
  
• 3 40" x 48" weather strips
  

Is this what you are after?

Well what We have in Excel is 6 Assembly lists that are stacked on top of each other and then each list is linked to the 6 lines on the Glass Order. Then at the end we have the Grand Total. So what I was thinking of doing was having one Layout with tabs, the first one would be the Glass Order and the next tab would be the assembly list like what we have in excel but I can't figure out how you would do that in FMP. Not sure what too Do, Jonathan

The Filemaker book Advanced Filemaker Techniques for Developers by Moyer and Bowers covers exactly this situation. It's an excellent book.