I have a solar table that I want to convert to Gregorian; After changing the format of the table, I face a problem because to establish a connection with the fact table, a one-to-one relationship is created and I need a one-to-many relationship, on the other hand, the ID I used for the date table is for the product ID and is in the table. In my fact, there are two ID columns, one is the ID of people, the other is the ID of the product.[enter image description here](https://i.sstatic.net/b8XrlgUr.png)

In your opinion, where is the problem with my date table? Did I choose the wrong ID to connect with my fact table, so the connection is not established? do i need to modify my date table or others?