Complicated - 1:1 field data from a query to table

[hoodoo]

Hello!



I just wrote page full of info, but my laptop crashed, so now I'll try to explain everything as briefly as possible.

We are making a database for a car rental company. When a customer logs in, he writes his personal data in one form, and then continues to a form connected to tblBookings, where he choses a car to be rented and dates for rent. Each car has a specific CurrentRate, which is how much the car costs for one day. In query qryAmountsPayable amount of days for rent (from tblBookings) are calculated and multiplied by a car's rate in a new field "AmountsPayable".

The problem is, we have a table tblInvoices, where invoice ID, rental date, car ID, and the AmountsPayable amount from qryAmountsPayable is showed for each corresponding car. The problem is, we do not know, how can we get the AmountsPayable from qryAmountsPayable to tblInvoice corresponding record.

I would REALLY appreciate help here.
Thanks in advance.

I don't know why, but I cannot upload database file in this site, so I uploaded it elsewhere (https://files.fm/u/9cyyrurd)
Login: Admin
Pass: pswd

[orange]

You may get some ideas from this or this.

Good luck.