You'll have to forgive me, I am very new at this and either not understanding or not communicating correctly.
The impression that I get from the original response is that there is no way to connect the tables within Quickbase, that I'd need to export the standards table to a spreadsheet, do all the sorting and parsing manually, then import the resulting spreadsheet to the measurements table. This would be done once a month and would frankly take more time than just manually entering each of the performance metrics and using the lookup fields to connect it to the standard.
when we say "mapping" the record ID into the related standard field, does this imply that there _is_ a way to import from a spreadsheet and have the imported data lookup information from another table?
