I am a new user trying to rebuild a database from an older version of filemaker, with filemaker 10.
We are a manufacturing company.
I have two main tables, the first is a customer file, when a customer wants to order something we create a customer file, with customer name, contact info, part name and part number, the quantity ordered and a purchase order.
The second table contains all of the information about the individual parts as well as a chart of when we send the customer the parts. For example if the part# is 333, and the customer orders 1000pieces, we may send them 500 on december 1st and 500 on december 2nd. the product file shows this. so there may be many different product files for the same part.
My main problem is in shipping. I want to be able to have a shippiong data entry layout. where i can select a date, then customer name from a drop down value list, and the address will pop up (based on info in the customer file) then enter what we will be shipping to that customer on any given day, like part#333, and i want the description of that to show up (based on product file info). i will also need to enter how many palletes we are sending, and by which frieght carrier.
then i want to select whether i need a bill of lading or a packing slip.
and i want to do this for each company that i am shipping to on any given day.
and then run a script, which will take this info and print it on the bill of lading or packing slips for wach company. (i have layouts for the bill of lading and packing slip with fields that match the shipping data entry.)
this is how the database is setup now, and i was asked to basically keep it the same but put it on a new version if filemaker.
HELP please, thanks