Access Form

[siebel2002]

I have a form which text boxes for the user to fill in the name of the customer visited, customer location and the date of visit.

Every time the user fills in new set of data, I want a subform to show a lsting of the data records containing the above 3 pieces of information. This is to enable the user to see at a glance all the customer sales calls.

I would appreciate any tips on the best way to do this.

Thanks!

 

[gusbrunston]

Hi, Siebel.

Seems like a main form / sub form.

There is a record for each salesman in "tblSalesmen".

There is a record for every visit by every salesman in "tblSalesVisitsDetails".

The two tables should be related one-to-many: One salesman to many visits.

The main form displays the record from "tblSalesmen".

The sub form displays the records from "tblSalesVisitsDetails" which contain the key field of the selected salesman (in continuous view).

The subform displays all existing visit records for that salesman, and the user enters the new visit information in the next record.

It gets a little more complicated if you want to limit the detail records to the visits to a particular customer, but not much.

See Northwind database examples "Orders" and "OrderDetails". (Northwind comes with Access).

I expect to have a great day! Gus Brunston An old PICKer, using Access2000
padregus@attbi.com

 

[siebel2002]

Thanks for the feedback. Yes, that is the line I have taken and it works like a charm!

Have a great weekend!