I'm a bit stuck with my database. It's relatively simple and only for my use but I've hit a big problem. I have a master table that has several fields, one of which is related to another table that I can select from a lookup. This second table has gotten too big and I want to break it up into smaller table, depending on category. I want to be able to select an option (? this is a field) in the master table, and then only see a selection of the second table in the next field's lookup list. I think I may have to split this second table into smaller separate tables, but how can I tell the field in the master table which table to look to.