Skip to main content
Question

Relating Existing Projects to Countries(in Team Complete Project Manager sample app)

  • April 27, 2020
  • 0 replies
  • 24 views

Hello,

Reference here is the "Team Complete Project Manager sample app", Table to consider is:

  • Project

Let us just say after addition of 50 Projects there comes a need of relating them to countries which basically means "A Project is running in one or more countries".  Countries were not in the picture when the app building initially started but is required now.

For this the Countries table was created(storing just a list of countries) & related to the Projects table(type Text (reference proxy) on Project Name), what would be the provisions of relating existing 50 Projects to their corresponding Country values?( I was exploring usage of API_ImportFromCSV, was wondering if there are more efficient ways to do this in case existing Projects number is much larger than 50?) 

Also 1 Project can have many countries so it has to appear as multi select field in the Add Projects form.

Similar need is encountered in a real application, Please suggest.

 

 



------------------------------
Himanshu Sharma
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
Typically this would be done with a many to many relationship.  One Project has Many Project-Country Assignments and One Country has Many Project Country Assignments.  There are techniques to help quickly assign countries to a project so they don't have to be done in a typical "Add Child method.

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