Need help on Ms Access

[aamirsq]

Hi Guys & Grlz,



I was working on this database and got stuck, i hope some one can help?

The idea is "A company keeping tracking of renting equipments and customers.
The customer can take multiple equipments.
Each equipment has a unique ID. (alphanumeric - XXXX#####) depending on the selection of rented item (XXXX).
The equipments can also go for maintenance and after maintenance it should be available again for rent.
The customer can pay either as cash/credit card but some fixed amount is required.

thanks in advance

File size was exceeding so i uploaded my file here

href=http://www.filedropper.com/equipmentrentalcompany

[orange]

Here is a free, generic data model that may give you a starting point. It is generic and all parts/entities may not apply to your situation.

Here is a general database design approach: