Hello all. I am new to QB and trying to set up an app for my small manufacturing/service business to try to get away from clunky spreadsheets now that we have a growing office workforce. My question is this: I have a 'Job Log' table where any new job (generally 25-50 jobs/day) is entered and assigned a job number. This tracks jobs from processing through to delivery. However, with my industry (construction) we are required to revisit these jobsites in the field for further service work.
I am looking to create a separate relational table (unless there are more viable options that might be suggested) that is automatically populated with field data (i.e. Job #, Address, etc) upon the creation of a new entry in the 'Job Log'. Is this possible and how might that be done? Thanks for your help.