Skip to main content
Question

Table Relationship From Imported Excel Data

  • October 15, 2019
  • 0 replies
  • 26 views

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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
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
------------------------------