I haven't used Access extensively and I'm currently in the process of building my first database. Someone suggested I use a lookup table to make it easy to complete the forms and keep the database semi-normalized. I was told to put options for multiple fields in one Lookup table with a group id for each field, then build a group lookup table. The person that suggested this has since left and my db is in limbo. Previous to leaving, it was suggested to find a way to have a form use the group lookup table then pull the values from the larger lookup table based on the group id. I am also having probems with my primary key. I have one form filling out multiple tables. I have the persons ID number as the primary key in all the tables. Is there a way to make it so the person inputting the data only has to put the ID number in the form once? Any help would be greatly appreciated. Thanks, Cory.