I have a database that my employer has assigned to me to create. I have three pieces of information that end users need to be able to: A. search by B. have autopopulated in forms C. One is unique: pipe number only one number is assigned to each piece of pipe. Coil number is assigned to many pipe numbers: coil number One is assigned to many coil and pipe numbers: heat I have 10 lab tests that are performed on each of those items(coil, pipe and heat). I have set up the lab tests as individual tables and each must have coil, pipe and heat in the table. I need to have coil, pipe and heat associated with one another so that when the end user searches by or enters one of the three the other two fields will populate or remain empty (if not in database). I am stumped, I cannot figure out how to join the tables to auto populate and do I put coil/pipe/heat in one table? They are related to one another. Pipe is the only unique number in the database. I am working under a strict time deadline. HELP! I am using Access 2007 and I am not an advanced Access user.
