Linking values

[November]

Hello,

I'm not familiar with Access very much and this is my situation:


I've got a table Routes with RouteID, Route, Route_price; a tabe Invoices with InvoiceID, Units, Route, Route_price, Total.
I've got a form, where I input Units, choose Route from the combo box.

Needed action:

I input Units, then choose Route, the corresponding Route_price should be chosen, shown and multiplicated with Units. The Total must be shown.
The Route, Route_price, Units, Total must be saved in table Invoices.

I don't know how:

pick Route_price according to selected Route and multiply it with entered Units and then show Total.
store all values in Invoice.


Will be gratefull for help

 

[Uncle Gizmo]

I would suggest that you have a look at the "Northwind traders" example database that comes with MS Access. If you don't have it, you can download it from here.

This example database shows how to set up an order system for a fictitious business. It demonstrates the use of a subform on a main form, allowing for the selection of sale items and quantities.

This example should provide the functionality you require, and more. Once you have studied this example, If you have any questions please post back.