I would like to limit the data in a table field to the value of a field in another table. I have done this by using a seek() in the field validation. Is there a better way of doing this. If I edit the first table without the lookup table open, I get an error. Thanks.
Richard G. Lewis