Updating Problem

[ietprofessional]

I created a relational database in access which has a customer table, product table, rep table, and salesinfo table. All of the tables connect to the salesinfo table for example:

CustomerTable          SalesInfo
customerid-------------customerid
customername           productid 
                       repid
                       units
                       price
                       etc.

My problem is I want to allow the user of the database to edit the units and price in the salesinfo table and the only way I can do this is to pull directly from the salesinfo table. The problem is the user will only see the customerid, productid, etc, instead of the customername, productname. How can allow the user to edit records and also allow them to view the logical information such as the customername instead of the customerid?

Thanks!

 

[Trendsetter]

Build a form built on a query that links the salesInfo to the CustomerTable via the customerID - the resultant data from the query will hold the customer's name.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk