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
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
No, that is correct.  What field did you use the build the relationship?  Maybe you used the transaction date to build the relationship and not the formula field for the first day of the month.  You need to use that formula field.