Bringing Back Records

Discuss the database features

Bringing Back Records

Postby quarkrad » Mon Nov 18, 2019 8:15 pm

Sorry for basic question - I've just started to use Base. Having created a db (table) of many recipe entries is it possible to 'bring up' all those recipes that contain, e.g. milk? I have created a form and can search the Table for milk but it only show one recipe - I have keep pressing on Search to scroll through all records/recipes. Is there a way of showing/presenting all the recipes that contain milk? Or does it not work that way?
libreoffice on ubuntu 16.04
Posts: 67
Joined: Mon Nov 03, 2008 10:01 am

Re: Bringing Back Records

Postby UnklDonald418 » Tue Nov 19, 2019 7:12 pm

Without having a sample of your database it would be difficult to give you specific advice.
A simple query something like
Code: Select all   Expand viewCollapse view
SELECT  ID, "RecipeName"  FROM  "MyRecipes" WHERE "MyRecipes" ."Ingredient" = 'milk'

will deliver a list of all the recipes containing milk. That is known as filtering. That query could be used as a data source for a Base form with a table control to display the results.
Then by selecting an item from that table a full list of the ingredients for that recipe could be displayed on a SubForm.
Look here for some examples using filters
Subreports with Basic code and "power filtering"
Filter/Search with Forms (leveraging SubForms)
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 - Windows 10 Professional
Posts: 1326
Joined: Wed Jun 24, 2015 12:56 am
Location: Colorado, USA

Return to Base

Who is online

Users browsing this forum: No registered users and 3 guests