interfacing invoicing with inventory system

[machtenx]

ok I have a database for invoicing, and the plan was to have a button with a script that copies and pastes the part number, searches for that, then copies and pastes the quantity of that part and pastes it in the inventory field. problem is how do i get filemaker to add these two numbers? also if there is a much easier way to interface invoicing with inventory please let me know. thanks

 

[machtenx]

Another question: How can I make it so that once an invoice is processed, it will no longer allow further processing?

 

[lebisol]

"problem is how do i get filemaker to add these two numbers"
dfine a calculation field:
c_AddNums = Field1+Field2
If u really need to develop a Sales-Invoices system I would suggest u look into getting a book called
Special Edition Using Fileamaker Pro 5
by Rich Coulombre and Jonathan Price.
the book is about $30-40.00 and follows the example of sales-invoices system (and then some) It would be worth buying it as it will answer A LOT of your future questions!
All the best!

> need more info?
:: don't click HERE ::