Auto fill a field based on 2 other fields

I have 4 tables:  "Loads Hauled", "Commercial Facilities", "On Farm Bins", and "Distance".  The "Commercial Facilities" table is a list of facilities where loads can be hauled to.  The "On Farm Bins" ...