db tables:
project: id, name, desc, portfolio_id (fk)
portfolio: id, name
relationship: portfolio may contain many projects, a project can only be associated with one portfolio.
requirement:
user enters project information (id, name, desc) via project create form.
he can then enter a portfolio via portfolio create form.
the question lies now how can the user associate a project with a portfolio?
The solution is to create a ‘partial’ project update screen, accessible only from the portfolio screen, that includes a project drop down list to pick from. A selected project is then associated to the portfolio ($_GET) and saved to the database via update record.
Any direction on how to build please?