I have one table of bugs for Software A. Software B, with its own table of bugs, depends on software A to some small extent. Sometimes bug blockers for Software B are in the Software B table, but sometimes they’re in Software A. I need a field which can accept either. Is this possible? It seems a field can only link to records in one table, not many. But this can’t be true, can it? It’s a pretty basic function.
I am aware that the preferred way to deal with this is to contain all these entries within one table and use views to differentiate, but it really doesn’t make sense in this case. In fact, these softwares are so different that I had them in separate bases, until I realised that there was no way to access the data (prior to sync) from one base in another.
These records also have very different fields, so if I were to represent them in one table, I’d have extraneous fields for all the records.