I've noticed that I'm getting back two copies of my post. Is that happening to others?
> Family Table (holds address, home phones, and primary addressee link) Did I understand that there was a bill-to column here also? > Patient Table (holds name, personal phones, e-mail, date of birth, family > and "bill to" links) > Transaction table (holds date, time, patient link, etc) > Transaction detail table ( links to transaction table, holds line item, > price, quantity, patient share, and payments/credits) My reflexive inclination here would be to not have the patient share as a separate column, but a separate line item. Each line item with it's own bill-to, using the patient id for their share. Eliminate bill-to's from other tables. > I'm moving toward changing this hierarchy, putting the Patient table at the > top, with the family table just being an incidental (and temporary) location > link. Yep. > I kind of like the idea of a person having several different > addresses so maybe a separate linking table is actually needed as Bill D. > suggests. It works well in the app I mentioned. Same for Phone/Fax > One last thing. I've always had charges and credits in the same column in > the trans. detail table, with charges being positive currencies and credits > being negative, simple summing them establishing running balances. Anyone > object to that method, or should I separate out credits into their own > table? Like so many things it depends, but if it haven't gotten in your way so far, I don't think there is anything inherently wrong with it. Ben
