Form for editing: group and sort records by values in related tables

  • Thread starter Thread starter L Mehl
  • Start date Start date
L

L Mehl

Hello --

This topic did not come up in searches using keywords I could think of,
although it has likely been discussed before.

In my app the form for user edit/entry of PartsPrices.Price must be sorted
by columns in related tables:

PartsPrices
-----------------
PartID
DatePrice
Price

PartInfo
-----------
PartID
PartName
PartCategoryID

PartCategories
---------------------
PartCategoryID
CategoryName

Form records consist of 4 columns
DatePrice, PartID, PartName, Price

and are to be grouped by CategoryName (does not have to appear on the form)
and sorted within groups by PartName.

I can get PartName to appear in the record using DLookup, but it is slow and
clunky. I can't sort on this looked-up value, and need help on this.

I need help in adding the grouping by CategoryName.

Does anyone have ideas on how to do this?

Thanks for any help.

Larry Mehl---Outgoing mail is certified Virus Free.Checked by AVG anti-virus
system (http://www.grisoft.com).Version: 6.0.637 / Virus Database: 408 -
Release Date: 3/20/2004
 
I learned about updatable queries, created one with the columns I needed,
and pointed the form to it. The form disables all fields except
PartsPrices.Price.

Things work now.

L Mehl
 
Back
Top