Forum Discussion
There are several ways to do this. One way is to create three connected sync tables into an app which contains a table for the LOBs.
Then you will have all of your data in one app with a table, reflecting the information you need from the reviews. Then check what the key field is of your list of LO in this app and create hardcoded formula fields in each of those three connected sink tables to match those values. Then create relationships between the LOBs and the reviews to roll up any totals you like.
Feel free to post with any questions or contact me directly at mark.shnier@gmail.com. If necessary, I can hop on a quick call for up to one hour to get you sorted out at no charge. You are new to Quickbase and I'd like to see you get off to a good start.