> On Aug 19, 2021, at 10:59 AM, Rich Shepard <rshepard@xxxxxxxxxxxxxxx> wrote: > > On Thu, 19 Aug 2021, Rob Sargent wrote: > >> Yeah, but my quibble is the the table you described up-thread. Your >> contact table contains next_contact? I think that column should be >> normalized out. > > Rob, > > Why should I have a separate table with one column: next_contact? The > next_contact date is associated with a person and the date that person was > contacted. > > Rich sorry, wasn’t clear: person_nbr, next_contact On the premise that there can only be one next date. > > > >
