Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: TheExample
- Order by date
-
Database Relationships
I do have forms and subforms. I was trying to create a query that would pull all of the data together. I will try a report/ subreport. Any ideas of which would work best? Main project then have the sub projects as sub events?- TheExample
- Post #5
- Forum: Microsoft: Access Tables and Relationships
-
Database Relationships
Thanks for the quick response. Ok here it goes. Thanks so much for even trying to help me :) Project Table (One to many relationship) EventID EventName StartDate EndDate AssignedTo SubProject table (Many to one EventID but Many to Many progress) SubEventID (One) EventID (Many) StartDate...- TheExample
- Post #3
- Forum: Microsoft: Access Tables and Relationships
-
Database Relationships
I have 4 tables. Project table (main project information) SubProject table (events each related to the main project table with a foreign key) Project Progress (progress toward main projects) Sub Project Progress table (progress observed towards sub projects.) The problem is created when all...- TheExample
- Thread
- Replies: 5
- Forum: Microsoft: Access Tables and Relationships
