Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Different tables for tracking different kinds of activity, one tracked by date and the other by year

Topic Labels: Base design
228 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Leslie_Davol
5 - Automation Enthusiast
5 - Automation Enthusiast

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!

1 Reply 1

Hmm if the two different types of activity have very similar data / fields, I'd just keep them in the same table I reckon