I’m rather inexperienced, but have a very rudimentary idea of how I think this is supposed to work.
Some background data:
Version: 184.108.40.206 (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,