G
Guest
I'm fairly new to Access and would like some help with creating and relating
tables in my database. I'm creating a database with the following in mind:
I have a table with a bunch of securities in it and each security can have
an Issuer, Servicer, or SyntheticAssetCP or any combination thereof. Each
Issuer, Servicer, or SyntheticAssetCP can be rated by SP, Moodys or Fitch or
any combination thereof. Each SP, Moodys or Fitch rates the Issuer, Servicer,
and Synthetic Asset CP with the same fields (i.e. all three agencies give the
security a long term rating, a short term rating, etc etc). Sometimes they
won't give a rating in one of the fields.
I'm struggling to figure out how to relate these all together. Any help
would be much appreciated. Thanks!
tables in my database. I'm creating a database with the following in mind:
I have a table with a bunch of securities in it and each security can have
an Issuer, Servicer, or SyntheticAssetCP or any combination thereof. Each
Issuer, Servicer, or SyntheticAssetCP can be rated by SP, Moodys or Fitch or
any combination thereof. Each SP, Moodys or Fitch rates the Issuer, Servicer,
and Synthetic Asset CP with the same fields (i.e. all three agencies give the
security a long term rating, a short term rating, etc etc). Sometimes they
won't give a rating in one of the fields.
I'm struggling to figure out how to relate these all together. Any help
would be much appreciated. Thanks!