By the way, just looked at the thread you posted and I feel that there should NOT be two lookup tables in that situation; statuses of court cases are the same logical types of entity, are they not? "OPEN PENDING TRIAL", "CLOSED CONVICTED", etc (assuming these are actual possible statuses), could all go into a single table, thereby eliminating your problem, and you would still not need a different lookup tag to sort through the data in the table. I don't know anything about legal data, so perhaps I'm missing something.