Question Access database help, multiple copies

[Sanci]

I have problem with my access database "Video Rental Store", so if anyone can help me, I would appreciate it. Here it goes: One movie have few copies, how to rent copy, ant put it back when it is returned?:banghead: Than you!!

 

[Sanci]

So one movie would be (in case there are 3 copies) put 3 times in tblProductItems, but only once in tblProducts?

I see why there are customer_id and rented_date, so I can see who rented movie and when,and maybe when it will be returned.

Can I put Returned or not (Yes/No) field somewhere, so if returned it can set customer_id and rented_date to null, and can I create form(like RentalRecord) that will update all this fields?

Thank you for you help!

 

[Sanci]

Ok, I understand you. I could build a form for RentalRecord where I would have field with customer_id and customer_name and movies he/she rented. Next to every rented copy I could put button return, and delete button(if copy is damaged, so I can delate it from table). So delete button is simple to create with wizard, but button return I have options code builder, macro builder, and expression builder. Could I do this with expression builder? It's seems to me easiest way, and I don't have experience with codes, and macros.

I'm sorry to keep bothering you, I really appreciate your help!