Hello, help please!!
I’m making a relationship where an account has several types of currencies (USD; Euros, Yen, etc) (1:M) and each currency has historical movements. The relationship to present the movements by currency doing a search entering the account to see which currencies have already achieved, but once I access the currency I can not see their historical movements. What type of relationship should I generate in this case?
I have 4 tables, the people table, the currency table, the portfolio table (where I relate people and currencies) and the historical table
In the history table I am storing the ID of the person and the currency, with the data of the transaction, date and amount
as you can see in the image, when I select the coin I get the data of all the coins, not the one that corresponds
Thanks for your support