Forum Discussion

JohnRokoczy's avatar
JohnRokoczy
Qrew Member
4 years ago

How to import MULTIPLE tables beyond the intitial one

I'm testing QB, and can't believe I can only import one table when I create an app.... that is unfathomable.  And before anyone says, "Yes, but you can 'connect' to a CSV file or build it from scratch...
Data import and export
Relationships
JohnRokoczy's avatar
JohnRokoczy
Qrew Member

Thanks Mark! 

 

The "import" function was definitely hidden... it should be a plainly-stated 3rd option alongside "build from scratch" and "connect"...

 

Now that I have the 2 tables, I was able to establish a relationship between the 2 but there's no clear way to tell it what the primary and foreign keys are.  Is there a secret way to establish and define what fields in the child table are related to the parent?

 

John

 



MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
np, when you look at the field list, there is a gold Key that indicated the Key field.  In Quick Base each table may have have a single Key field.  

When you make a relationship, you can either allow Quick Base to create a field to join he tables (the foreign Key) or you can select one of the fields that you imported.   A reference field (what you call a foreign key) may also be a formula field.

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