How to create Events within Projects?

[Evgenii_P]

Hello everyone, 

1st table called Projects, where new projects are created.

2nd table is called Events. 

How do I organize my tables, references, etc., to be able to create events within a project? Ideally, I need to be able to see a list of events; then, when I go to a detailed view, I need to see a list of associated events and be able to add a new event to the project I'm currently looking at.

[alexstory · Accepted solution]

In events table add a column called "ProjectID".  Use that to reference the projects table.  Hit save and you should now have a "related events" virtual column in your projects table.  add that to a detail view and you should be able to add events from right there in the projects detail view.  Make sense?  

From Events, reference projects.  If you set "is a part of" you can add events from within a projects form too.  

[Evgenii_P]

Thank you!