Skip to main content
Question

Two summary fields to one table

  • April 6, 2022
  • 0 replies
  • 18 views

Forum|alt.badge.img+7
I have three tables:
Trucks
Equipment
Scanned Assets

In the trucks table, I have a summary field - Distinct Count - Scan Dates in the last 30 days
The summary field works fine and the number is correct.
I have the same field in the Equipment table, set up exactly as the trucks, the field doesn't work. Everything is zero.
The scanned assets table shows a date and the info for the truck/equipment every time they are scanned. (Imported from a csv)
Report links for both tables show all scans in 30 days but I need a distinct count for each table since they are tracked separately. 
Why would one work and the other not? Both use truck/equipment number as primary key, tables are nearly identical. 
Thank you


------------------------------
Steven Pearson
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+16
  • Quickbase Alumni
  • April 6, 2022
Can you explain your table to table relationships. Which are parents and which are children?


------------------------------
Mike Tamoush
------------------------------