Table Structure Idea help

[TechMike]

I need help with table structure, They keep way too much info. Now that I have said that here is what I need help with. I have been asked to make a small "Ha ha" Database this is what small became. Most of the data for this is in a spreadsheet now I know I can import it where I want it. The main concerbn is that the main piece of information would be the Job Address. Because of all this other information I was not really sure how to setup the tables here is what I have started .

Buyers Information (tbl)
Fname
Lname
Address City State Zip (with a look to qry)"cool zipcode code"
Phones (3)
Email
Ect.

Buyers Realtor Info (tbl)
Fname
Lname
Company Name
Address City State Zip (with a look to qry)"cool zipcode code"
Phones (3)
Email
Ect.

Sellers Information (tbl)
Fname
Lname
Address City State Zip (with a look to qry)"cool zipcode code"
Phones (3)
Email
Ect.

Buyers Realtor Info (tbl)
Fname
Lname
Company Name
Address City State Zip (with a look to qry)"cool zipcode code"
Phones (3)
Email
Ect.

Job Information (tbl)
Address
City (Filled in by Zip)
State (Filled in by Zip)
County (Filled in by Zip)
Zip (with a look to qry)"cool zipcode code"
RoofType (With a lookup to A list tbl)
RoofCondition (With a lookup to A list tbl)
Job Notes (memo)

Appointment Information
Time (now real sure how these time and date will work)
Date ( " )
Appointment Type (With a lookup to A list tbl)
Contact Name
Salesman (With a lookup to Salesmen Table)
Appointment Results (memo)
Referral

As I mentioned this data is in a spreadsheet and most every row has all of the above information ("ha ha, small") but I wanted to get some other Ideas and see if anybody had a better one before I tryed to make it all work.

Thanks

 

[TechMike]

Pat,

Here is what i was "was" thinking or what i was tring to do.

The sellers address and the buyers address will most likely be the same as the job address but sometimes it is it will be just the owner, so the job address is always there but it may differ from the buyers or the sellers, as in the case of investment prop then it is going to be the realtor address. I was tring to make it smaller than what It was starting to turn into. I am going to setup the tables in the morning and follow your advice once i get them built and I can see more in detail what mean. Thanks for your quick response. I have read many post/replies or yours your advice always seem to lead us stray sheep back to the flock.

Mike

 

[TechMike]

Pat,

It has been a bsy day I made it this far let me know if I am going the right direction

 

[TechMike]

Pat ,

I am in the same boat as you way much work thanks anyway but if you do get the time just let me know ..

Thanks again
Mike