How to change the value of a field depending on the date?
I'm new in this forum. I tell you my doubt, I have two related tables, in the first one I have the information of a few equipments (name, model, id, serial number, State...) and in other one what I have it is the State and the from date and end date of this State, the relation is 1:M, because an equipment will be able to happen for many different states.
I have two questions, the first one, might it be the relation 1:1, because an equipment will be only in a state at the same time?
And the second question (that worries me more enough) is, how might it do in order that filemaker verifies the date in which we are and modifies the field "State" of the first table (Equipments) depending on the states and the dates of the second table in which we store the states?
Thank you very much.