Craig Farrell (1/25/2011)

---

spmaguire (1/25/2011)

---

Pretty much,the IsUsed column is used to check for when someone wants to delete that particular entry/row. if an existing worklog record has used a particular column...

I made the change on the WorkLog table, as suggested. I also noticed that there were three relationships that were linking the table with itself, so removed those too.

Grant Fritchey (1/25/2011)

---

spmaguire (1/25/2011)

---

I was considering creating a new table called DeleteModify and then have a bit field within that table. Holding two records for true and false. Then...

I was considering creating a new table called DeleteModify and then have a bit field within that table. Holding two records for true and false. Then creating a relationship...

Craig Farrell (1/25/2011)

---

Some quickies in addition to Grant's questions, and I agree on Cascades. I hate them with a passion. It's almost worse then the hidden logic behind...

I was reading up...