SyaefulBahri3
6 years agoQrew Trainee
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
------------------------------
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
------------------------------