What is the simplest way to link 2 tables together by the serial number field and create a report that includes fields from both tables? one to one table relationship.

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

I have a user inventory file (TABLE# 1) and have added a date field "Last Scan Date".   

I want to populate this field from another table (TABLE # 2)  using the "Serial Number" field to link the records together.   The table relationship would be "one to one".  

TABLE 2 will be imported from a spreadsheet, and I want to REPLACE all existing records every time the import is run.

How can I set this up to run on a monthly basis?   

Photo of George

George

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 59,768 Points 50k badge 2x thumb
No problem.

Make the Key field of Table 2 to be the Serial number field.

Then make a relationship where 1 Serial at able 2 records has many Inventory Table 1 Records. Use the serial field on the inventory table as the reference field on the right side of the relationship.

Since the Table 2 has the scan data field, just do a lookup in that relationship to get that down to your Inventory file.