Forum Discussion
o59393
6 years agoPost Prodigy
Date relationship problem
hi all I have 2 tables, both contain a day by dat date column in yyyy-mm-dd format. There is a code asociated with each of the days. Code SP/B-0144.11 starts on 2/15/2019, while SP/B-0171.00 ...
- 6 years ago
Get rid of the many-to-many, they are evil, make things not work properly and are almost always avoidable. Implement a bridge table of unique key values.
Greg_Deckler
6 years agoCommunity Champion
Get rid of the many-to-many, they are evil, make things not work properly and are almost always avoidable. Implement a bridge table of unique key values.
o59393
6 years agoPost Prodigy
Hi Greg_Deckler
The problem is that products are added on a daily basis. Maintain a key of product+country will be kinda difficult.
Any suggestion?