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

Question

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".&nbsp; 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) &amp; related to the Projects table(type&nbsp;Text&nbsp;(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&nbsp;ways to do this in case existing Projects number is much larger than 50?)&nbsp;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.
&nbsp;
&nbsp;
------------------------------Himanshu Sharma------------------------------

markshnier__you · Answer

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
------------------------------

himanshusharma · Answer

Thanks for replying Mark.I agree with the suggestion of the type of relationship.Let me elaborate the scenario little further:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Projects&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Countries(was introduced late in the development,&nbsp;1)&nbsp; &nbsp; &nbsp; &nbsp;ABC Campaign&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1)&nbsp; France2)&nbsp; &nbsp; &nbsp; PQR initiative&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2)&nbsp; India3)&nbsp; &nbsp; &nbsp; &nbsp;XYZ Intercom&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3) UK4)&nbsp; &nbsp; &nbsp; &nbsp;LMN ....&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4) USA5)&nbsp; &nbsp; &nbsp; &nbsp;DEF ....&nbsp;&nbsp; &nbsp; are 50 + like these&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;( there are 4 only for now)Project 1 could be running in India, UK, USA (at least 1), similarly any project can have any number of related countries.To Solve:

Client did not initially say anything about the Countries but later gave a list of each Project running in associated Countries which is needed to be incorporated in the QB app(that is when the Countries table was created).&nbsp; how to efficiently update the 50+ Projects with associated countries?
From now on a New Project should be associated with 1 Country at least, so would need to have multi select list of Countries(from the Countries table) in the Add New Project form?&nbsp;&nbsp;

Thanks. :)------------------------------Himanshu Sharma------------------------------

markshnier__you · Answer

Yes, if it's just a few countries, you can create a Multi select field. It is not clear from you post what reporting you need by Country and a multi select field can be limiting down the road requiring the app to be reworked.

But sure, just create a multi select field for country.

You can import into a multi select field via Excel by massaging the country list to be a semi colon delimited list. You would need to export the Projects table along with its Key field (probably Record ID#] and then add a column in Excel for the countries and then import back onto the app.

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

himanshusharma · Answer

Project &amp; Country Relationship:
Drop Down in Add Project Page:
The values are not appearing as Country Names (France, India, USA, UK).I tried changing&nbsp;Add Country&nbsp;properties(this is the drop down appearing in Add Project form):Chose "Select Shared Field"-&gt; Chose App -&gt; Chose Table Countries &amp; Field name Country Name
On saving it gives a length error

------------------------------Himanshu Sharma------------------------------

Forum Discussion

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

Related Content

Show related records

Filter out some records on related table

How to relate two tables with the key to a third table?

Join Existing Data

Building A Project Tracker Based on Existing Tables