Issue 106828 - Filters in Forms/Subforms to find records with selected subrecords
Summary: Filters in Forms/Subforms to find records with selected subrecords
Alias: None
Product: Base
Classification: Application
Component: code (show other issues)
Version: OOo 3.1.1
Hardware: All All
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-11-11 17:33 UTC by pepevilluela
Modified: 2017-05-20 10:45 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description pepevilluela 2009-11-11 17:33:06 UTC
I have created two tables and I have made a relation between them. Then I have 
used the assistant to make a Form with a Subform: The tipical master/slave 
When I apply a filter in the subform is applied ONLY in the subform, so I can 
see Master registers that haven't any record in the subform.
The logical way people expects this do it is that filter in the subform filters 
records in the Master form that have no subform records, because people used to 
use it to find Master records containing the subform record they selected.
I think this worked well when openoffice Base made forms with Write, in 
previous versions.
This is a feature seen in Lotus Approach and never seen in MS Access.
Comment 1 Frank Schönheit 2009-11-13 10:44:21 UTC
I remember we talked about this in the Base development team years ago already,
concluding "yes, that's a reasonable request" ...

Grabbing and confirming. Still, I cannot promise any concrete target, so putting
this on "OOo Later" for the moment.
Comment 2 ameliab 2011-04-05 19:28:51 UTC
As a user but not a programmer, I just wanted to add a note of support for this issue.  (i.e., please don't let in languish in "OOo later" forever).

Think of the really simple situation of an address book with phone numbers coded as a separate table/subform (since you can have multiple numbers per entry).  You would expect to be able to be able to search by the phone number as easy as by the address.  

Or a customer database with lists of transactions as a subform -- you want to filter out only the customers who have made a transaction last month.  Instead, you get *all* your customers, but only last month's transactions listed for each.
Comment 3 Marcus 2017-05-20 10:45:37 UTC
Reset the assignee to the default "".