Sure, the flat data file has;

OwnerID

OwnerName

OwnerAddress

OwnerCity

OwnerState

OwnerZip

PropertyDescription

County

etc.

So John Smith might have OwnerID=1 in Tarrant County. And there might be Smith, John in Reno County that has OwnerID=205. I'm still wrapping my...

Yes, the sql you've posted is the basic design I am currently using.

The purpose of the billing table is to capture all the work performed by the different agents. This...