Posted 15 September 2011 - 11:27 AM
In my core table, I want to create a lookup table to refer to. How complicated can I get this?
I'm trying to create a column for printers in our office. It has 4 required fields: location, name, ip, model. At each location, we have similar printer names because we have similar departments. I want to know how to make the core database table I'm using pick the right printer by narrowing down the options.
Site 1 - Receivables 1 - 184.108.40.206 - Fricken Laser Jet
Site 1 - Receivables 2 - 220.127.116.11 - Old Ink Jet
Site 2 - Receivables 1 - 18.104.22.168 - Fricken Laser Jet
Site 2 - Receivables 2 - 22.214.171.124 - Another Fricken Laser Jet, with sharks attached to it
Core Database Table
[open the drop-down for using a lookup to Printer Table]
[choose site] -> [name appears in drop down after picking site]
[choose name] -> [location-name-ip-model displays in Cored Database Table column called Printer Table Lookup]
We can't have someone just write "Receivables 1" in our printer column, because there are so many. But I want to make it simple for people entering it. Pick the site, pick the name, everything fills in. Can this be done with Access 07? I'm not quite sharp enough to know if I can, and I'm slowly making my way through tutorials, trying to find if it exists.