Too many records!!!

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

I want to restrict the number of records displayed on a main form so that I
don't have to wade through hundreds of records for which there is no data
displayed on the subform.

I am really struggling to get the main form to only display records where
there is data present on the sub form AND the data can be updated AND new
records added.

I can write a query that returns the correct number of records but because
the sub form is on the many side of the relationship I have to either Group
or use Unique Values or Records which then means that the dataset cannot be
updated or records added.

Can anyone help please??
 
Bill said:
Hi All,

I want to restrict the number of records displayed on a main form so that I
don't have to wade through hundreds of records for which there is no data
displayed on the subform.

I am really struggling to get the main form to only display records where
there is data present on the sub form AND the data can be updated AND new
records added.

I can write a query that returns the correct number of records but because the
sub form is on the many side of the relationship I have to either Group or use
Unique Values or Records which then means that the dataset cannot be updated
or records added.

Can anyone help please??
Click to expand...

In clause with sub-query should do it.

SELECT * From MainTable
WHERE ID IN(SELECT ID FROM ChildTable)

That In clause should even work as a filter.
 
In clause with sub-query should do it.

SELECT * From MainTable
WHERE ID IN(SELECT ID FROM ChildTable)

That In clause should even work as a filter.
Click to expand...
Rick - That did it, many thanks.
Bill.
 
Back
Top