creating a form

[mlbwhf]

Hi guys, your always a great help.


i have the following tables:
Customers (Cust_ID, Cust_name, Cust_address, Cust_email, Type)
Rent (Rent_ID, Cust_ID, Equip_ID, Equip_name, Rent_start, exp_return_date, act_return_date, weekday_num, weekend_num,hire_ income)
Produce, on demand, for a particular customer, a record of all previous hires. This application is to run on-line (i.e. produce the output on a form). The input parameters (e.g. the individual customer) should be picked from a drop down menu (e.g. Combo Box)

[orange]

Sounds like homework assignment.
Do you have a specific question?
Where is the Equip(ment) table?

Why do you store weekday_num and weekend_num?

[mlbwhf]

will yes it is
i need it because i needed to calculate the income as there is different rates for weekend & weekdays ( is there a way to distinguish weekends & weekdays?)
Equipment (Equip_ID, Equip_name, Equip_brand, Sup_ID, weekedays_rate, weekend_rate, Delivery_time, Category, Qty_in_stock)

[orange]

What is Sup_id?
Where are the various Rates per TimePeriod per Equip_Id?

For a great reference on Relational Database Design Concepts read
http://forums.aspfree.com/attachment...2&d=1201055452

Create an entity relationship diagram before any coding.

For ERD info see http://www.rogersaccesslibrary.com/T...lationship.zip

For a great guide to the Database design Process see this article that has an example within the document.
http://www.rogersaccesslibrary.com/f..._Databases.zip

Good luck with your project.