I have a table called TCNO which is a table containing all the information concerning Microsoft patches. I have another table containing all the Air Force bases where we have a server installed. I want to find a way to show what servers have what TCNO's installed.
I have a many to many relationship with TCNO and Base so I need another table.
How do I construct my third table to link the others?
I thought of the following:
tcnoID, lookup on tbl.tcno primary key
Base_Name, lookup on tbl.Base primary key
and Installed YES/NO
How can you have lookup field tcnoID and Base_Name primary keys? They are null values in my new table which I named tbl.installedTCNO.
I have a drop down list on my main page (switchboard) that lists all the Bases and a command button for TCNO.
On the TCNO form I wanted two lists: what's installed, what's not for the current server... capture a double-click on an entry in either list to switch it to the other, or double click and bring up another form that has a check box "Installed" YES/NO.
Regards,
Steve
I have a many to many relationship with TCNO and Base so I need another table.
How do I construct my third table to link the others?
I thought of the following:
tcnoID, lookup on tbl.tcno primary key
Base_Name, lookup on tbl.Base primary key
and Installed YES/NO
How can you have lookup field tcnoID and Base_Name primary keys? They are null values in my new table which I named tbl.installedTCNO.
I have a drop down list on my main page (switchboard) that lists all the Bases and a command button for TCNO.
On the TCNO form I wanted two lists: what's installed, what's not for the current server... capture a double-click on an entry in either list to switch it to the other, or double click and bring up another form that has a check box "Installed" YES/NO.
Regards,
Steve