I'm putting together a fairly complex database with around 10 tables which need to be related to each other. I'm fairly new to this Access lark and am getting a bit confused about look ups and where it is best to add them. What should you consider when trying to decide whether to put a look up into the original table or entering in on a form instead? The end users of this database will probably never use the tables to enter data.