I am building a database that a employee can evaluate Group leaders and or Team Members or Team Leaders, I have bult the forms and built alot of tables but now I need to get it all together as a working solution. I really want this to be as automated as possible so the data collected is not scewed. as simple as the emploee who is evaluating puts in his or her ID number and name department shift auto fills. and the one getting evaluated they choose the name and that information is auto populated. I have read alot of access books over the last 3 weeks but grasping some of the stuff has been difficult. last data base I created was in Dbase3 (showing my age) my main trouble is the relationships between tables. any help would be great here is a sample of data the actual tables of people are 4000.