I have the task of creating a database in which users can quickly obtain details about a certain part by searching for the catalog number.
The issue I am having is that when the catalog number is selected via combo box, the parameters from the fields below are not updating to match.
I have tried coding to update the fields based on other questions i have seen around the internet, but errors tell me that they may not be the same problem I am having. I also have the feeling that the fields in my form are not set up in a manner actually utilizes the relationships I created.
I have linked below a sample of my database
<Removed by mod>