Auto-populate the records in one table to match the records in another table

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I have X tables, each representing a different material type:

Material Type 1

Material Type 2

...

Material Type X

I need a Summary Table that consolidates the records from all of these tables with a "Type" field so that everything can be filtered.

What I want is for the summary table to automatically add new referenced records each time a record is added to any of the Material Type tables.

I can create one-to-one relationships between all of the Material Type tables and the Summary Table, but then I still have to go through and manually select each and every record in each and every Material Type table (I think). Maybe I am thinking/going about this wrong.

Thanks for any help!

Photo of Jason

Jason

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
The design of your tables is going to make working with this app very cumbersome and limiting and repetitious to work with.

I strongly suggest that you consider scrapping the current design in go to a single table of materials where they are categorized by Type.

Maybe if you explain what your app needs to do, we can advise on an appropriate structure for the tables and their relationships.
Photo of Jason

Jason

  • 0 Points
I have a construction drawing. The person will have to enter all of the materials that are on that drawing. There are up to about 7-8 different types of materials. I don't want them to have to leave that form until they have entered all the materials for that specific drawing. So basically, before this, all the drawings would have been entered into a Drawings table. Then, in the material take off form, the user would first select the relevant drawing from the dropdown, and from there be able to enter all the different materials from that drawing. Ideally, I don't want them to ever have to re-select that drawing for each item they enter, because that's redundant work (one find and click multiplied by 1000 times is a lot)... Maybe I should consider the fact that each item will have to be entered one-by-one? This just seems like an overly tedious process and I could see the end user potentially abandoning Quickbase for their old Excel sheet.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,448 Points 50k badge 2x thumb
Have you considered setting it up do data entry can be done in Grid Edit?  That look and feel is very similar to Excel with copy and paste and "fill down"