Pull a number from another table
I ahve a table that breaks down "Fire Calls" in table 1. I have table 2 that needs to have a formula of "total of fire calls" divided by ESD 7 calls. I haven't had to pull numbers from another tabl...
Forum Discussion
Depending on what you're trying to do with the # you can also construct a 'Master' table that acts like a global parent in your DB for areas where you need to create scalar values that persist across the entire system. The idea is you create a table with a single record and you create relationships to any tables that you need to summarize data for, and the reference field is formula-numeric set to the value of '1' so that every record is related to your master. This way you can create summary fields that you can bring into your master record for reporting. So you can imagine # of calls this month as one value, another for last month, and then a simple formula field that calcs the difference for month over month.
------------------------------
Chayce Duncan
------------------------------
Thanks, Mark and Chayce. That's some really great info.
I think this one is simple enough to just do a table to table relationship and bring that total over to table 2 and be done with it that way. Neither table is huge like you describe Mark, but this is likely just the easiest and quickest way. Was just hoping maybe there was a simpler formula way to do this. No worries. I think i can make this happen.
------------------------------
Gonzo - A Newbie, but learning fast. (Former SmartSheet evangelist who is quickly converting to QuickBase)
IT Director City of New Braunfels
------------------------------