I've been working on building relationships between 4 lists, call them A, B, C, and D, where you can only choose specific B values based on what A value you chose, etc. I kept a table which contained a record for each possible A, B, C, and D combination.
Currently, the drop-down lists of the conditional values still work. However, when I try to view the table on which I related these conditional values off of, it's gone! It says that the table is missing, and each field is labeled <Table Missing>.
I read on this forum also that recreating the table in the relationships tab of databases would fix it, but it proved to be fruitless for me. Any tips?