T-Shirts, place your orders!

I went through the thread and collated every post into a huge spreadsheet. Then I created a database table called products and put all the shirts in it. Then I created a table called orders that could map people to the products. Then I took the spreadsheet and ran it through Access so that I could change the order matrix into the one-line inserts I needed to populate the orders table. Then I mail-merged the Access database into a Word document containing the INSERT statement for the orders database, and then ran all of the SQL against the database. Finally I created a page to show the tshirt orders, and a template to show each product. I had to put the shipping calculation onto that page, and re-implement PayPal Fees calculation. At the end of that I added the PayPal Website Button and set the values of that to dynamically populate with the information from the orders database table.

Took about 3 hours. But still far quicker than anything else I could've done to work out how to collect money from 169 people.

woah. brilliant. and way over my head. but brilliant. thanks!