[Solved] List not filtering

Creating and using forms

[Solved] List not filtering

Postby sqw68 » Wed Feb 01, 2017 6:52 pm

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

Postby sqw68 » Wed Feb 01, 2017 6:55 pm

Attached if it helps
Attachments
Housing Database.odb
(118.53 KiB) Downloaded 123 times
OpenOffice 4.1.3
Windows 7
sqw68
 
Posts: 8
Joined: Tue Jan 31, 2017 5:46 pm

Re: List not filtering

Postby UnklDonald418 » Fri Feb 03, 2017 5:40 pm

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.6 & LibreOffice 6.1.5.2 - Windows 10 Professional
UnklDonald418
Volunteer
 
Posts: 1326
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Re: List not filtering

Postby Arineckaig » Sun Feb 05, 2017 3:13 pm

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
Arineckaig
Volunteer
 
Posts: 828
Joined: Fri Nov 30, 2007 10:58 am
Location: Scotland


Return to Forms

Who is online

Users browsing this forum: No registered users and 4 guests