I think I understand normalization and have since separted several tables into several more tables. I also think I understand relationships and have created each table with AutoNumbers as the PK and have included the FK field in each corresponding table. I then created the relationships by connecting the PK's to the FK's.

My question is this: How do I create a form that incorporates data from several different tables and automatically fills in fields for which data is already in the system

Suforms and combo boxes. Subforms are linked to the parent via the PK / FK relationship, and combo boxes can help display the lokup text while storing the ID number..