Need roadmap or glossary of terms -- Act! to Infusionsoft challenges

I need to create two tables which include unique index keys, and a couple of data elements tied to each index key – such that I can enter the unique index key on the Contact page and it will pull over the two dependent fields. I’d like 100 unique keys in a one drop down and 50 in another. This to me is “relational database lingo”. We build the child table, or form, and from the parent, we pull over data from the child. Like sheets within a workbook in Excel. I want to enter something in Sheet A and have it perform a lookup from Sheet B & C and populate Sheet A with those record’s details. Perhaps this is accomplished from a campaign, or by using an internal form? Help!