Can I create a field which looks up data from another record within the same table?

Hi there,  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 w...