Forum Discussion

Qrew Member

8 months ago

Lookup a value with multiple conditions into a field in a separate table

I have a table called "Forecasts" with many different forecasts at different time periods. I want to create a field in another table that pulls a specific value from the "Forecasts" table into a fie...

ZacharyStein

Qrew Member

Thank you so much for your reply!

Yes the tables are related. It is a many to one relationship where the forecasts table is many. When I create a new field what field type would I use? I don't see an option for summary fields.

------------------------------
Zachary Stein
------------------------------

ChayceDuncan

Qrew Captain

8 months ago

You don't set the type for a summary field - it's determined automatically based on the type of data you're summarizing. So if lets say you're summarizing the 'total forecast' it will likely auto-determine that is a numeric field and create accordingly.

------------------------------
Chayce Duncan
------------------------------