display specific record in a form

[davem1901]

First, let me state I am a novice at using base. I have used MS Access for several years and recognize that the two are only alike in that both are referred to as relational databases. Access includes a construct that allows what they call a combo box to select a specific single data item from a specific field and it then filters the records in the form and displays the remainder of the data associated with that selection. In other words it finds a specific record based on the selection made in the combo box.
I don’t know how to reference that event in base. but I have a database of plants and their associated data. (height, width, water, sun, soil, zones, etc) I want to be able to find all of that data for each plant. I have no idea how to go about doing that in base.
Any and all pointers, assistance, examples, and anything else that can allow me to do this will be tremendously appreciated.
I am running
Version: 5.2.6.2 (x64)
Build ID: a3100ed2409ebf1c212f5048fbe377c281438fdc
CPU Threads: 6; OS Version: Windows 6.19; UI Render: default;
Locale: en-US (en_US); Calc: group.

Thanks in advance
Dave Miller

[Ratslinger]

Hello,

This is easily done in Base using a filter table. It is a table with one record used solely to hold information from a source (ie: list, combo box etc.) which is then used in an SQL statement to retrieve data for the required record display. You can find much info on this in this post - Filter/Search with Forms (leveraging SubForms).

Also, here is a very simple example using a table filter to retrieve records: BikeFiltering.odb

There are many more examples throughout this forum using table filtering.

An additional thought, you can also have sub forms which display associated data based upon the selection in the main form. A sample of this can be found in my answer on this post.

LO documentation can be found here.

[davem1901]

Thanks so much for the reply and the info. As I said I am a newbie to base and so will most likely take a while to go over all of this to see if I can understand everything you shared.