I need to add a Text field and a Choice field to a summary table.
I import data like shown below in the Fills table. I have a summary table, Trades, that add up the profit for each trade.
A Trade is made up of multiple fills which the Fills table shows. I summarize them in the top Trades table. But I’d like to add notes to each Trade. That data is associated with the summary Trade table, not the Fills table. There is other information that I need to record that is a 1:1 relationship with the Trade, not the Fill.
It looks like I can’t add those fields to a summary table. How do I make that 1:1 relationship with a summary table?
I made a TradeSummary table that has an EntryTime field to try to link the TradeSummary table to the Trades table, but when I add a TradeSummary widget, I don’t get a “select by” option.
Any help is appreciated
