Skip to main content

Here’s my scenario:



  • Every day I make a plan, I screenshot the plan and put it in a ‘plan’ table

  • Every day I might make 3 trades, each of which are stored in another ‘trades’ table

  • I have an interface where I review my daily ‘daily review’ table


I would like to include in my ‘daily review’ interface, a grid showing all the trades for the day (so the daily review’ interface would need to list trades with the same date as is on the daily review table/interface. Each day could have many trades. But a specific trade can only belong to one date. I am not sure how I can do this.


Can anyone help?


Hey Mark, in your Daily Review table, if you’d be alright with making the primary field display a date, you could consider linking each trade to a daily review record on creation like so:


Trades table:




Daily Review table:


Daily Review interface:




I made a bunch of assumptions as to how your base / interface was setup though, so lemme know if I’ve got anything wrong. If you could provide screenshots of your base setup and interface setup that’d be super helpful too


Aaaaah so like, do it in reverse, I think I know what you mean. I’ll take a stab at it now…


This worked, thank you @Adam_TheTimeSavingCo !


Reply