Many-to-many

[frons]

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:

1. How should I set the relations between these two tables?
2. How should I prepare the query that allows me to select ALL the records from the tblHerbs table?

Any help will be greatly appreciated.

[June7]

tblSeasons would be used twice. Relationships builder will show them named like: tblSeasons, tblSeasons_1. Same for tblClimate.

If you want to select all records, just don't use filter criteria.

Can some herbs be associated with both seasons and/or both climates?