I have two lists, one is an asset tracer that contains computer names (table1). The other is a log that contains a description of all the work done on the asset (table2). It contains pc names, an ID, Date and a description. Is there a way to setup a key in table1, that queries table 2, matches the computer names in both tables and either displays the description from table 2 or counts the log entries, with a link. When the user clicks on the link, it takes them to table2.
Table1
ID, PC#, etc…
Table2
ID,
PC#,
Description,
Date
I believe this is an inner join.