Updating Problem 1

[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, when I pull the data to a form, the user will only see the customerid, productid, etc, instead of the customername, productname. How can I 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 that is based on a query that joins the 2 tables via the customerid. Select the Customer name as part of the query and this will appear in the field list available for the design of the form.

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

 

[ietprofessional]

When you join the tables with a query how can you do updates?

 

[Trendsetter]

If the fields on the form are bound to the fields in the query then any changes to the data in the forms will be reflected in the data tables.

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