I'm confused about lookup fields in tables. I've read on this forum that they are bad and should not be used, but why would microsoft create a wizard to create them if they are that bad. I can understand the arguement against them but I don't know how to design my tables without them.
Let's say I have one table of cars which has different fields. One of the fields is the owner. I have another table called owner that has information on the owners. How do I link these tables so each car entry has one owner? I can use the lookup wizard and have it reference the owners table. Or I can drag the primary key in the owners table into the cars table and create the relationship. Which way is better or, are there other, better ways to link simple tables like this without using lookup fields?
One step further if I wanted to create a form, would it be best to link it to the car table, or a query that combines the tables?
Sorry for the long post, just trying to learn something new.
Mike