Hi All,
Hope you're well.
I've been scratching my head with this one. Basically I am trying to create a table that will store the login credentials for the different cloud storage accounts (tblCloudStorages). The username for the Cloud Storage will be an email address but it could either be an actual email account or an alias email address tagged onto an actual email account. Because of this I have two seperate tables, one for actual emails (tblEmailAddresses) and one for the Aliases (tblAliases). For managing these I have created a junction table called (tblEmail_Aliases) where I store the foreign key for each email/alias to link them together. I've attached a screenshot of my relationship table to help you better understand.
My question is how would I go about referencing either the EmailID or AliasID to be used for the Cloud Storage Username? I tried linking to the junction (tblEmail_Aliases) table but just end up with both email and alias assigned to the same Cloud Storage details. I also tried a junction tables for Alias+CloudStorage and Email+CloudStorage. Again, same result, just ended up with both emails assigned to the same Cloud Storage.
Any suggestions and advice would be greatly appreciated please.
Many thanks,
Dom
Hope you're well.
I've been scratching my head with this one. Basically I am trying to create a table that will store the login credentials for the different cloud storage accounts (tblCloudStorages). The username for the Cloud Storage will be an email address but it could either be an actual email account or an alias email address tagged onto an actual email account. Because of this I have two seperate tables, one for actual emails (tblEmailAddresses) and one for the Aliases (tblAliases). For managing these I have created a junction table called (tblEmail_Aliases) where I store the foreign key for each email/alias to link them together. I've attached a screenshot of my relationship table to help you better understand.
My question is how would I go about referencing either the EmailID or AliasID to be used for the Cloud Storage Username? I tried linking to the junction (tblEmail_Aliases) table but just end up with both email and alias assigned to the same Cloud Storage details. I also tried a junction tables for Alias+CloudStorage and Email+CloudStorage. Again, same result, just ended up with both emails assigned to the same Cloud Storage.
Any suggestions and advice would be greatly appreciated please.
Many thanks,
Dom