new db design URGENT

[Guest]

need to incorporate the following: Company Name (pk), company address, company phone; Contact Person (pk), address, phone, fax, e-mail,; Project title (pk), location, start date, lead origin, lead status. Also need to incorporate a contact log with the following fields; Project title (pk), Contact type, date, notes, Action date, action notes... these categories will need to appear four times for each record

I really need some help in figuring out how to put this all together and make sure the information is all related etc. End result will need to be a form that multiple users can use to key in data

Any help most appreciated

 

[Cheryl Fischer]

There is a sample Contact Manager database that can be downloaded from the
following link that may give you some ideas for your own design or which can
be modified for your use:

http://www.microsoft.com/downloads/details.aspx?FamilyID=6534F03C-518E-4868-
9BDC-20BAADB1C710&displaylang=en

hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

need to incorporate the following: Company Name (pk), company address,

company phone; Contact Person (pk), address, phone, fax, e-mail,; Project
title (pk), location, start date, lead origin, lead status. Also need to
incorporate a contact log with the following fields; Project title (pk),
Contact type, date, notes, Action date, action notes... these categories
will need to appear four times for each record.

I really need some help in figuring out how to put this all together and

make sure the information is all related etc. End result will need to be a
form that multiple users can use to key in data.