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.
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.
Thank you!