Goodmorning, I have problems with multiple instances of the same foreign key in a single table.
What I have is the tabe tblHerbs that contains some records which are linked to the same foreign table (i.e. season1Herbs and season2Herbs are linked to the same table tblSeason, and so on...).
At this point I have two questions:
- How should I set the relations between these two tables?
- How should I prepare the query that allows me to select ALL the records from the tblHerbs table?
Any help will be greatly appreciated.