
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 30, 2024 03:48 PM
I am tracking two kinds of activity related to a list of locations that I keep in a table called LOCATIONS. One kind of activity (programming) has very specific dates. The other kind of activity (development) is hard to pinpoint in time so I do not want to assign specific dates, but I do want to know what calendar and fiscal year activity is happening. My question is, should I create one table for all location activity, so I can see it all in one place for each location (when grouped by location), or should I create two tables and then look at my LOCATIONS table to see all linked activity? Or maybe just track development activity in the LOCATIONS table? Thanks!
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Dec 01, 2024 10:12 PM
Hmm if the two different types of activity have very similar data / fields, I'd just keep them in the same table I reckon
