Ok scrapped my first go and trying a database and want to get the second try right.
I have Houses that report to Chapters, Chapters report to outreach, and outreach reports to the state
So I will have tables for each tblHouse, tblChapter, tblOutreach,
but each table will have a lot of the same kind of informatiion; name, address, phone#, Email address etc
so should I name the fields with refernce to the table?
Example
tblHouse
HouseName
HouseAddress
HouseCity
HouseZip
HousePhone
tblChapter
ChapterName
ChapterAddress
ChapterCity
ChapterZip
ChapterPhone
or is that overkill because I will have to refer to the tbl to refer to the field anyway???