Hello all,
Mgmt has asked me to add a module to our existing database to keep track of computer assets (desktops/laptops). Because Microsoft uses the same Windows Version (21H2, 22H2, etc) for different operating systems, I had to build a junction table to handle the many-to many relationships - which I've done. So far so good.
I have a continuous sub form on the Main Menu form that correctly displays the information that I want, based on a query ComputerList_Q. When I call the Add New Computer form, I have three text boxes on it that I would like to display the OS Edition, OS version & End of Life date *after* the operating system has been selected from the ChooseOS_F which is called from the SelectOS button. I have tried different approaches: select statements in the textbox Control Source, different queries, etc. but I cannot get the three text boxes to display the data that I want.
Some specs:
1. Due to performance issues, coupled with the fact that this thing will eventually be split, I do not want to use DLookup.
2. The AddComputer_F uses parameterized querydefs to write to the table.
Attached is a concise version of the DB with the pertinent tables, forms & queries.
Start with the MainMenu_F -> click on the Add New Computer button -> Click on the Select OS button -> Choose an OS then click the Assign to computer button. When this returns to to the AddComputer_F the junction table ID is correctly passed.
How do I get the three text boxes to display the information that I want?
Thanks in advance!
-Bill