Hello All,
I am using Access 2000 to create a mailing list database. I am wondering if the table fields and relationship is correct. Here are the fields for the
table tblclient on the one side.
Client_id
FirstName
LastName
MiddleInitial
Title
ContactType
Organization
Alt1Address
Alt2Address
City
State
Zip
County
Region
Country
Entity1
Entity2
Entity3
FaxNumber
WorkPhone
CellPhone
EmailAddress
PracticeGroup
Source
LastUpdated
Comments
AgencyType
Here is the linking table fields on the many side tblcontacttype.
Contact_id
Client_id
ContactType
I also have some "Lookup" tables that I use to populate
the tblclient fields during data entry. Here are the lookup table fields:
tblAgencyType
tblCounty
tblClientStatus
tblSource
tblCountry
tblContactType
I have already defined all the fields for all the tables.
I have also created the Data Entry Forms and inserted some sample data. Please critique if you see something wrong or if another approach is better. Thank you very much for your assistance in advance.
I am using Access 2000 to create a mailing list database. I am wondering if the table fields and relationship is correct. Here are the fields for the
table tblclient on the one side.
Client_id
FirstName
LastName
MiddleInitial
Title
ContactType
Organization
Alt1Address
Alt2Address
City
State
Zip
County
Region
Country
Entity1
Entity2
Entity3
FaxNumber
WorkPhone
CellPhone
EmailAddress
PracticeGroup
Source
LastUpdated
Comments
AgencyType
Here is the linking table fields on the many side tblcontacttype.
Contact_id
Client_id
ContactType
I also have some "Lookup" tables that I use to populate
the tblclient fields during data entry. Here are the lookup table fields:
tblAgencyType
tblCounty
tblClientStatus
tblSource
tblCountry
tblContactType
I have already defined all the fields for all the tables.
I have also created the Data Entry Forms and inserted some sample data. Please critique if you see something wrong or if another approach is better. Thank you very much for your assistance in advance.