3 Replies Latest reply on Feb 6, 2013 2:53 PM by philmodjunk

    Lookup next - related files

    LelandNye

      Title

      Lookup next - related files

      Post

            

           I need to look up a billing rate from a related file.  My database has four tables, customer, job, timesheets and rates.  The job and rate tables are related to the customer file by a customer#.  The timesheets and job tables are related by a contract number.  The rate file has three fields; customer#, date, and rate.  Different customers have different rates and the rates change at different times for different customers.  Each time there is a rate change, a new record is written for each field. 

            

           I need to look up the most current rate each time a new record is written to the timesheet file.  I am trying to get the rate by the following path

           timesheets -> job -> customer -> rate

            

            Any suggestions would be greatly appreciated.

            

           Thanks