kufray

Thanks alot for you effort. I have a better understanding. I really appreciate it. my email is kufray@gmail.com just incase u need anything

and [color:red]proceed accordingly. please could you throw more light on what steps the script should take after. How do I compare the time of yesterday and today to find out if the limit has expired or logged in?

I want to build a login system. More like a ticket login system where a customer walks up to a system operator and presents a ticket with a number. The operator enters a search through the DB for the code. When it turns up the operator should make that code valid and should be notified if already made valid previously so as to avoid a double entry on the same code. I created a table for all the codes. a. How can I build a timer script so that it makes the ticket valid and starts counting till 12am, and makes the code invalid when looked up after 12am (like maybe the next day) b. How should the operator login in the ticket, ...drop down, check box? etc?? so as to activate the count timer till 12 am. Should it be drop downs valid/invalid options where the operator just selects a value?

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?

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

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

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