Ordering System

[BigAl]

Hi People

I hope someone can help me, I have been using Filemaker of and on for a few years but mostly basic stuff. I am currently working on a system which can print purchase orders.

I have a file with one table in it at the moment. The table has a few fields such as Job Number, Product Code, Product Description, Qty Required, Line Total and supplier. The problem is that the user will enter all the items to be purchased for a particular job, which can be ordered from various suppliers so the user fills in the supplier field from a drop down box. Now what i want to do is have a script go through the table and print off a seperate purchase order for each supplier for the job number they are working on.

Can anyone point me in the right direction?

Thanks

Alan

[mr_vodka]

You should start from the related LineItems table. From there you can group by Supplier and print your POs accordingly.

[BigAl]

Hi

Yes that makes sense, but how do i get a script to print out the purchase orders for an entire job from all different suppliers bearing in mind that there are many different suppliers and each job can have from 1 to 100 different suppliers?

I can have the user select each supplier manually but i can't figure out how to automate this.

thanks

Alan

[mr_vodka]

From your job, you would use a Go to Related Record to get to related items. Then you would group by each supplier. since you want it to be on seperate pages, you would need to have it create a line break.