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

This should get you going!

Thank you very much for yor assistance.

Steve

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

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