Rental System

[Q2100]

Hi

I am in need of some help for a rental system i am creating... I have made the following Tables

Customer
Dvds
Rentals
Suppliers
Staff

I want to create a Master Detail Form for Rentals so i am able to show and make rentals for Specific customers. if someone could please provide me with some help..would be very greatful
Thanks

 

[neileg]

This kind of application is a bit of a regular in here. Try doing a search and see how you get on.

 

[pbaldy]

What exactly do you need help with? To display rentals for customers you'd have a form bound to the customer table and a subform bound to the rentals table, with the appropriate master/child link(s). If you're just making rentals, a form bound to rentals with a combo for customer. That combo has a row source from the customer table but is bound to the rental table.

 

[Rabbie]

This kind of application is a bit of a regular in here. Try doing a search and see how you get on.

Could it possibly be a school assignment?

 

[Q2100]

thanks but ive just figured this 1 out myself...

 

[neileg]

Could it possibly be a school assignment?

I assume so!