Yes - in a record (row) in 2 tables, some of the columns have the same data - for example we have a one column that indicates the state of their annual contract with us (good, needs renewing, in progress, don’t renew) and a second lets us know if we...

From what I understand, we’d want some separation since we may have a way to have “prospects/leads” and leads generated from other processes that might need to be groomed or catalogued separately, and that some of the data that is attached to a lead ...

Hi Julian - I think I am trying to do what you instruct here but not sure how to implement it. I have 2 tables that have a column with the same data. For example, a prospect table and a customer table. In both I have a column that is “status” which...