I have a sugarcrm application with many custom modules.
Two of these are accounts and tariffs. A customer can only ever be on one active tariff at any given time.
Take this example, a customer is on TARIFF A, then moves to TARIFF B, in say 12 months time the customer may move back onto TARIFF A.
I need to be able to show all three relationships?