We're a small screen printing shop. It's just me and my wife. I built a filemaker database to work as a workorder system and it's going good.
One thing i'd like to incorporate is a list of products available to print on.
We have about 5 different distributors we can get shirts from and they supply us with a CSV file of products. I can import these files into FMP.
Basically I'd like to have a conditional value list. A list of drop down fields where it get's wittled down as you pick from the drop downs.
So you'd start with the distributor, then type of garment, then the brand, color, size. Then you'd have narrowed it down to the final product.
Once the product is selected i'd like to somehow pull that (lookup) into the "Quote" record that we are doing for the customer.
Here is a copy of a vendors excel file. I put it into filemaker. So I guess i just need someone to build the layout with the conditional value list so i can look and reverse engineer it into my workorders database.