Multiple table references

I have a table whose 1 column is supposedly a foreign key from multiple tables.. This is my scenario. I have a 'tblTransactionTaxes' table which has an 'intReferenceID' foreign column. Then I have several transactional tables such as tblBills, tblInvoice, etc.. all of which has an intTransactionID column that i'd like to map to the intReferenceID column on tblTransactionTaxes. I'm having a lot of difficutlies on this. How should I handle these instances on my model using DevForce?

Thanks,

Lawrence

It's not actually an issue but more of a question.. We're currently normalizing our db and we've found difficulties controlling them in EF/DevForce, so what I was asking is if there could be a better approach on our scenarios, whether it be change our schema or handle things in DevForce. I've list down our scenarios below..

- A single table with multiple associations to another table. Say we have a tblBills and tblBillDetails. The first association is the intBillID which is taken automatically. The second one is a 'strOriginalBillNumber' field on tblBills that is associated to tblBillDetails' 'strOriginalNumber' field. We're having problems as to how to associate multiple fields between tables..

- A single column within a table with an association to multiple tables. This is what I was asking on my earlier post. We record all transaction taxes on 'tblTransactionTaxes' that was created from different types of transactions. Different transactions records lie on different tables (tblBills, tblOrders, tblInvoices, etc..) We have a column (intTransactionID) in tblTransactionTaxes that we'd like to link on these tables. Together with another column (strTransactionType) we'd like to link them up on these several tables.

Thanks,

Lawrence