I am trying to make a small accounting db and I have hit a dead end, my search bared no results as of how to make this idea work.
In the picture below you can see that I am trying to link multiple tables to one table
CreditDebit in this case, so I can use CreditDebit's ID (CD_ID) in the
BondDetails table as the
what I am trying to achieve is to have correct structure so that I could create a query that would tell me which table the creditor or debtor belong to based on their id and show their name (
CreditDebit table would have only one of the three ids (