I want to be able to make a column a date field and when this date arrives it should change the field used to indicate status from in stock to expired. My application is to track inventory for medication samples that are provided by drug reps for the practice.
In much the same way, I would like if when the field status is changed to distributed and the patient ID is occupied that it removes it from the inventory.
Any recommendations?
LinkedIn
Twitter
