Forum Discussion

SergioSergio's avatar
SergioSergio
Qrew Cadet
8 years ago

pull information from a field in another table from the respective field based on the month of the year

I have two tables. "Processing" and "Monthly Interest Rate". I have a field in the processing table that is called [interest rate] I have fields in the "interest rate table" called [JAN 2018], [FE...
Ask about Quickbase functionality
SergioSergio's avatar
SergioSergio
Qrew Cadet
8 years ago
Got it!!! 
Works!
Thank you so much!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    So in the end, did you simply do what I originally posted?

    You can set the Key field of your interest rate table to be a date field of the first of the month. Then in your detail table make a formula field of 

    FirstDayOfMonth ([My date field]) 

    Them use that to make a relationship to the interest rate table and the lookup the interest rate.