Forum Discussion

SyaefulBahri3's avatar
SyaefulBahri3
Qrew Trainee
6 years ago

Table Relationship From Imported Excel Data

Hi all,

I have created employee table name on Quickbase. There is an excel file I import directly to Quickbase as a table. I named it with "Assets Table", contains field as shown below.

Serial number | Quantity | Price | Total Price | Users

The "Users" field actually employee name on "Employee Table". Usually, I create manually the table and create table relation between Employee table and Assets table with "Each employee has many assets"

How can I create table relationship from "Employee Table" with "Assets Table", if "Assets Table" is imported from excel file and already contain data?

Many thanks



------------------------------
Syaeful Bahri
------------------------------
  • If you change the key field of your employees table to be the employee name, then the imported data will match up automatically. 

    On the imported data table and you would use the employee name as the reference field in the relationship.

    ------------------------------
    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach
    http://QuickBaseCoach.com
    markshnier2@gmail.com
    ------------------------------