Relationship between fields

  • 0
  • 1
  • Question
  • Updated 5 months ago
I would like to create a relationship between two fields, e.g. Date field and Value field.
What I am trying to achieve is simplified sales reporting.
Each project has specific payment schedule, e.g. 01 Jan 2019: £5,000, 01 Feb 2019: £2,500 etc. I would like to be able to specify this payment schedule by manually selecting the date in one field and specifying the amount in a second field. 
Then I would like to be able to run a report listing all project revenue by month and by project (like cashflow).
Any help with this will be greatly appreciated.
Photo of Rumyana Topliyska

Rumyana Topliyska

  • 70 Points

Posted 5 months ago

  • 0
  • 1

Be the first to post a reply!