Relasionships

[tobeon]

i want to make these two tables link

Products
Customers

.....
PRODUCTS
Rented by: (customer ID)

Customers
currently renting {Product ID}

but i want it so that a custoemr can rent lots of products at the same time but a product can only be rented by once customer

.....
PRODUCTS
Rented by: (customer ID)

Customers
currently renting {Product ID},{Product ID},{Product ID},{Product ID},

thanks for any help

 

[bat17]

As you want a One To One relationship between Product ID and Customer ID just add the customer ID to the Products table as a foriegn key.

HTH

Peter

 

[tobeon]

how exactly would i do that/

 

[SydneyGeek]

Presumably you want the Product to be available once it is returned, so another Customer can rent it? If so, the solution is more complex.
If you can give more details someone will be able to get you going.

HTH

Denis