I'm new to this so bear with me....
I have a table for "Supplies", and a table for "Tariffs". Each supply can have many tariffs (but only one is "live" at any given time).
Is there a way to add a field to my Tariffs table which would provide detail from the previous tariff?
So for example, Tariff 1 might be for the period 1 Jan 15 - 31 Dec 15 and be provided by "Supplier A", and Tariff 2 would be for the period 1 Jan 16 - 31 Dec 16 and be provided by "Supplier B".
In the record for Tariff 2, I would like there to be a field called "Previous Supplier" which for this example would provide the value "Supplier A".
Any thoughts / advice appreciated!
I needed something much more simple and was reading/experimenting establishing same table relationships without success (may be my records were not unique but did not have the time to troubleshoot root cause) for at least the last couple of hours.
What I wanted to achieve is to have a copy of the same field for the purpose of another report (did not want to rename the original field) only named differently, so I was trying a to build lookup and snapshot field(s) instead of what worked like a charm - a formula field referencing the parent field.
Posting it just in case others might be searching for something that simple.