Trying to set-up tables

[Vaimpir]

I am working on a DB for my company to keep track off employees and the clients that they have. Here are the fields I want:

*Employee
*Employee Email Address
*Client Name
*Client Mailing Address
*Client Contact Phone #
*Client Property Address (Home for Sale)
*# Bedrooms for Property
*# Bathrooms for Property
*Squarefootage of Property
*Sale Price of Property
*Pool on Property (Yes/No)
*Status of Sale of Property
*Follow-up Date (calculated 2 weeks after date record is entered)

Can someone help me on how to build the tables for this and how to normalize them.

Note: 1 Employee will have multiple Clients and 1 Client my have multiple Properties for sale.

Thank you in advance,

Steve

 

[sonny]

This should get you going!

 

[Vaimpir]

Thank you very much for yor assistance.

Steve

 

[Vaimpir]

Trying to create a form for date entry. I'm trying to include all fields from the tables. I use the wizard and build the form but it will not let me enter information into some of the the fields. Can someone tell me why?

Thanks,

Steve

 

[WayneRyan]

V,

What fields can't you enter data into? You are not supposed to enter
data into the AutoNumber fields, they will be filled out automatically.

Wayne