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
Sergio
I did watch the video via the link you posted.

What you want to do is very simple, so it will work.

Please answer these questions.

1.  Do you have a table of Interest rates, with 1 record per month.

2. Is the key field a date field?

3. Is that Key field loaded with the 1st of each month.

4. Do you have a field on the detailed transaction records with a formula of FirstDayOfMonth()

5. Is there a relationship based on that FirstDayOfMonth() field?

6. Are you puling down the interest rate in that relationship?