Good morning Team,
This is my first post, so I hope to explain my problem quite well.
Right now im designing a db to keep tracking on a corrective and preventive maintenance tasks, so i already have the tables and i'm working on the reports and charts I expected to fm gives me, but I wanna say to fm, that creates me a new record according to a certain logical criteria, let say:
I wanna keep track on all the injection molds my toolshop has and evaluate if they need preventive or corrective task,so I have a field to enter the number of shots that every mold gives me after a running, let say 13000 shots, after I input the number of shots, I wanna fm tells me that this mold needs preventive maintenance due a criteria on the number of shots, actually I'm planning to use 3 criteria let say 250000, 50000, 900000 shots, so I need fm creates me a new record with the preventive task, to programming it.
Sorry I wasn't clear.
Best regards
Pablo Ulloa