Windows XP 
Access 2000
Hi,
I started creating tables for a new financial Database. To simplify, I have a table "tbl_DEALS" that lists and describes a given security's characteristics (say, if it's a bond for instance, we would have [name of the borrower], [issue date], [type], [amount], [currency] and so on). I also want to create a field in that same table called "Syndicate" which would be a heading for a list of lenders under 1 specific security.
I therefore have an item Bond A in my table tbl_DEALS and under the Syndicate field, i will have a list of banks that are lending (bookrunners) to that bond issuer.
What type of relationship shall i create between those 2 tables (i also have a general tbl_BANKS that list all my universe of banks)?
Thanks in advance
Reply With Quote
