[Solved] List not filtering

Creating and using forms
Post Reply
sqw68
Posts: 8
Joined: Tue Jan 31, 2017 5:46 pm

[Solved] List not filtering

Post by sqw68 »

Hi,

Struggling to get a filter working.

Form name “TBL_Daily_Time_Sheet”
Field 1 lists “Job Number” from “TBL_Site_Number”
Field 2 list “Plot Number” from “TBL_Plot_Number” – this latter table also contains “Job Number” as a data field.

I’m trying to get field 2 to show only those Plot numbers that correlate to the Job number.

Syntax for field 2 is at the minute is
SELECT "TBL_Plot_Details"."Plot Number", "TBL_Plot_Details"."Plot Number" FROM "TBL_Site_Details", "TBL_Plot_Details" WHERE "TBL_Site_Details"."Job Number" = "TBL_Plot_Details"."Job Number"

Can someone assist?
Last edited by sqw68 on Tue Feb 21, 2017 12:43 pm, edited 1 time in total.
OpenOffice 4.1.3
Windows 7
sqw68
Posts: 8
Joined: Tue Jan 31, 2017 5:46 pm

Re: List not filtering

Post by sqw68 »

Attached if it helps
Attachments
Housing Database.odb
(118.53 KiB) Downloaded 209 times
OpenOffice 4.1.3
Windows 7
UnklDonald418
Volunteer
Posts: 1544
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: List not filtering

Post by UnklDonald418 »

Have you looked at
viewtopic.php?f=100&t=42845
If your problem has been solved, please edit this topic's initial post and add "[Solved]" to the beginning of the subject line
Apache OpenOffice 4.1.14 & LibreOffice 7.6.2.1 (x86_64) - Windows 10 Professional- Windows 11
Arineckaig
Volunteer
Posts: 828
Joined: Fri Nov 30, 2007 10:58 am
Location: Scotland

Re: List not filtering

Post by Arineckaig »

Attached if it helps
The file greatly helps to indicate the source of the problem - many thanks for uploading it. The tables listed in the file indicate the application may well be intended for a serious commercial purpose: it is by no means a simple or straightforward database. The design and implementation of a commercial database generally require the skills and experience of a professional, whose fees almost always end up less costly than (would-be) cheaper routes.

There is no short-cut to learning the design principles of a Relational Database, without which problems will arise as soon as Base is used to create forms or reports. Furthermore this forum is not well suited for helping with design errors as even the recommended introductory tutorial runs to close on 200 pages. Another comprehensive guide, that may help as it is written primarily for commercial users rather than computer science majors, is: “Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design” by Michael J Hernandez that is also available in ebook versions.

Suggesting the need to gain an initial understanding of these design principles is intended to be helpful even it may not appeal: frustration that will arise otherwise will almost certainly prove to be worse. Learning how to develop a relational database is a fascinating challenge and can indeed be rewarding.
When this issue has been resolved, it would help other users of the forum if you add the word - [Solved] - to the Subject line of your 1st post (edit button top right).
AOOo 4.1.5 & LO 6 on MS Windows 10 MySQL and HSQLDB
Post Reply