Ask Your Question
0

LibreOffice Base: Tables, Queries, Filters, and Forms

asked 2018-03-23 20:34:27 +0200

NEUmemphian gravatar image

I'm rather inexperienced, but have a very rudimentary idea of how I think this is supposed to work.

Some background data: Version: 6.0.2.1 (x64) Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89 CPU threads: 4; OS: Windows 6.1; UI render: default; Locale: en-US (en_US); Calc: group

What I'd like to do is build a cross-referencing system. Let's say I have a Preferred Brand and a Preferred Model. A customer calls me and asks for a Competitor's Brand and Competitor's Model. I have the paperwork and can look it up that way. I've already built the LibreOffice Calc file for it. I can do a simple search function that way, but that is NOT how I want to wind up doing this.

I want to—ideally—use a ComboBox to be able to type in a Competitor's Brand. From there, I would like the data MATCHING the Competitor's Brand to FILTER all results to ONLY SHOW that Competitor's Brand, plus all available Competitor's Models that are within that Competitor's Brand AS WELL AS our Preferred Brand and the Preferred Model belonging to that Preferred Brand. (Four Columnar Labels requesting information from a Datasheet—Preferred Model and Preferred Brand (in case a customer requests such information instead of a Competitor's Brand and Competitor's Model).

My biggest hindrances—that I can see, at any rate—happen to do with understanding how each of the Form Elements (ComboBox, Listbox, Control/Form Properties, etc) are intended to be implemented as TDF has designed them, SQL, and why such an awesome program has such great traction and understanding in languages other than English.

I've tried following TheFrugalComputerGuy via his website and YouTube tutorial series, but there is TOO much to attempt to cover in areas that I am finding do not correspond to what I'm attempting to do. I've contacted a couple of the individuals listed on one of the "Professional Help" section. I've posted on reddit. Short of taking a local professional course for Access, I don't know if I'm even in the right place asking here.

In summation, I need help and humbly request your aid, assistance, and patience.

Your fellow LO user,

NEUmemphian

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2018-03-23 21:39:26 +0200

Ratslinger gravatar image

updated 2018-03-24 00:00:30 +0200

Hello,

What you are asking for is going to need more space & time than this forum can provide since you specify you are inexperienced. You would need to learn the basics of Base, databases, SQL and based upon your question macro coding. Any one of these can be daunting to a newcomer.

There are too many directions to take that your question can't be answered directly.

It would seem, with your stated background, it may take you many months to get something of this type working to your satisfaction. However, if you want a starting point, please review the LO Base documentation to start. It has many examples & step by step procedures. Click Here for page. Be sure to check out Getting Started section as well as the Base section.

For a small sample of what you are attempting, see this post (click here) and near the end of my answer you will find "Sample #2 - ProgressiveListboxes.odb' which you can download.

EDIT:

Here is another sample similar in what is done in first sample but different in the display of information - Base two parameters master-double filter . Near end of my answer is Revised form sample: 20171207 CRM SETA Revised. On the sample look at the form named "CompanyCallingRevised". You may also want to read the comments there for some guidance on getting a display of info in form.

Also, taking a course in Access (as you mentioned) while attempting to work with Base is detrimental. The two are different in many ways.

If this answers your question please tick the ✔ (upper left area of answer). It helps others to know there was an accepted answer.

edit flag offensive delete link more

Comments

Thank you for taking the time to respond!

I did feel as though it might take a while to learn, but I wasn't certain how beneficial/detrimental taking an Access class would be.

I will look into the information you've provided and give you more feedback post-dissemination.

Again, thank you for your honesty and promptness.

NEUmemphian gravatar imageNEUmemphian ( 2018-03-28 18:33:41 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-03-23 20:34:27 +0200

Seen: 534 times

Last updated: Mar 24 '18