Product Update

[kufray]

Hello every one I am still new to file maker and I really believe its possible to do great stuffs. I am in the middle of a program. Its suppose to have tables for products, patients and invoices. I made a form for the patients, where their medical diagnosis can be tallied up with their financial history. But I had to delete a product from the products table everytime I made a sale for the patient. Example. I have 25 pcs of a particular drug in the store, if i record 4 pcs for a patient, how will I deduct that from the drugs table dynamically. Please bear in mind. the drugs table has it own form so I can update a quantity of drug recently bought into the shop. I need to know how to update the quantity to drugs in the drugs table as I record for the patient.

Thank you very much

[LaurenKuhlman]

I would look at the use and purchase of drugs as a transaction and create a table for these transactions. For example, a purchase by the pharmacy (or hospital) of a drug would be a type of transaction with a positive amount and a purchase of a drug by a patient would be a negative amount. Then, create a summary field for the amount and this would be your current on-hand amount.

Edited June 17, 2009 by Guest

[kufray]

Hey Lauren,

thanks for your swift response. I get the logic now, but how do I configure the patient area to automatically make the valu negative on commiting the record?

At the drugs tabel I should have "remaining qty field". What ccalculation will equate the value entered at the patient area and the drugs area?

I have been in need of someone to put me through in many things.

I also have another challenge. to automatically get all dates at the start of the program, find those that equals to the current date and display a notification that theres a birthday. I got the script to find the birthday and display the notification, but it only processes the first value and doesnt run through out the whole records. Please How can I get around this to run through the whole database?

Finally I noticed u r certified How can I get certified even thought I am having troubles with scripts.

I hope I am not too demanding but this would be helful t

Thank you

[Fitch]

I agree that a transactions table would be a good way to go to keep a history of inventory updates. However, you'll probably want to store the updated total rather than summarize, or your system will eventually bog down. You'll need to create a script to manage this process.

[kufray]

Hey Lauren,

thanks for your swift response. I get the logic now, but how do I configure the patient area to automatically make the valu negative on commiting the record?

At the drugs tabel I should have "remaining qty field". What ccalculation will equate the value entered at the patient area and the drugs area?

I have been in need of someone to put me through in many things.

I also have another challenge. to automatically get all dates at the start of the program, find those that equals to the current date and display a notification that theres a birthday. I got the script to find the birthday and display the notification, but it only processes the first value and doesnt run through out the whole records. Please How can I get around this to run through the whole database?

Finally I noticed u r certified How can I get certified even thought I am having troubles with scripts.

I hope I am not too demanding but this would be helful t

Thank you

[kufray]

I thank you for the help so far. But How do I write that script. I really want to be proficient enough to write scripts effectively, usefull resources will be appreciated.

have suggestions on the type of script?

[Fitch]

An effective method to create a script is to create a new script, then add a comment for each step of the process. This allows you to say in plain English what you want to happen without thinking about FileMaker code. Then go back and start fleshing it out with actual script steps.

As for getting certified, you can start here:

http://www.filemaker.com/support/training/certification/

However, the certification test is not for beginners. It's hard even for experienced developers. It doesn't sound like you're where you need to be yet to take the test. Work on your FileMaker projects, keep asking questions, and study.

The FileMaker Training Series is pretty good:

http://www.filemaker.com/support/training/fts.html

Also: the FileMaker Pro 10 Bible by Ray Cologon, or you might like FileMaker Pro 10: The Missing Manual by Susan Prosser and Geoff Coffey.

[LaurenKuhlman]

There are lots of ways to make your patient transactions negative. I would use a multi-predicate relationship with a primary key and a text constant on one side. The text constant is a type that would get pulled into your record when you create it in a portal. Then, use this type with a calculation to switch the amount from negative to positive. This can be a little difficult to explain in words so, I attached a very basic sample file.

In regards to certification, I would recommend using the FileMaker Training Series. At your level of experience, you would likely benefit immensely from taking the FileMaker Training Series course. We teach it in Chicago, San Mateo and Philly. You can find listings of FileMaker Trainers as well as information on ordering the FileMaker Training Series here:

http://www.filemaker.com/support/training/fts.html

I hope this helps. Sorry for the gap in reply, I had forgotten to subscribe to the post.

Transaction.fp7.zip