Skip to main content

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

  • November 30, 2024
  • 1 reply
  • 19 views

Forum|alt.badge.img+4

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

TheTimeSavingCo
Forum|alt.badge.img+31

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