I'm about 20 years out from when I last did any development with Access and trying to keep a long story short, I'm trying to import data from a web filter that I inherited that has decades of people doing stuff with it, in order to identify and clean up redundant and no longer relevant rules, and given the tools that I have, Access is better than trying to do this by spreadsheet. I might be trying to run before I can walk here but in college my experience is using a relational database model.
I am making a form that currently has 2 combo boxes, 1 text box and an "enter" button. Here is what I have so far:
Combo1 - IP address table
PK - hidden
IP address 1 - visible
IP address 2 - hidden but displayed in the text box mentioned above.
Combo2 - Policy name table
PK - hidden
Policy name - visible
When I click the "enter" button I want the 2 PK values to be written to a 3rd table that will only contain the PK values of the associated IP and Policy in each row, but so far I'm not getting anything to populate. My latest attempt I defined 2 integer variables that on Click I have them set for "variable = Me![cbo].Column(#)". Then I have a couple of strings to build out a string "INSERT INTO tblJoin (IPID,PolicyID) VALUES (variable1,variable2)" followed by execution of that string. Again my join table remains empty.
If I can get this figured out I have several similar joinings that I am planning to perform and my ultimate goal is to expand the logic so I can prompt myself to enter an IP address and it will search all of the policies, exceptions, etc... that I am associating and show me everything that is associated with that IP, because the vendor product doesn't have an easy way to do this. I also plan to expand it to add and search by URL to find all of my rules where a URL is entered so I can try to clean up and consolidate redundant rules, but babysteps.
How can I write these hidden values from the comboboxes to this third table? Thanks!