Recent content by Sanci

You are not alone.:) I get upset and angry(sometimes even growl at monitor, not something I'm proud of), and than cool off (take power nap), and start over. It helps if I speak to somebody, you may be suprised how different perspective can be useful. But when I'm alone, here is one quote that...

Hi fortion and Patchy! How are you? How forum members are treating you? I'm very pleased, got help from Pat Hartman which I'm very gratefull for!:)

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...

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...

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!!

Hello everyone!!!