Organize Access Data/Building Relationships

[qwerty]

The form I am creating will be used to select the location you are working. When you select the location it would filter the data for specific location. I was told to create a many to many relationship and a junction. I created the junction based on what I was told but the populated data is not appear. I want it to retrieve the data and organize it specific categories.

[June7]

The idea of a junction table is to represent many-to-many related data. In your case, per your other thread https://www.accessforums.net/showthread.php?t=74274, you have a table of Locations and a table of PlantSpecies. If each location can associate with many species and each species can associate with many locations, then this is a many-to-many relationship. You have to do data entry into the junction table to define these associations. The junction table will have foreign key fields for both location and species. Then you create records by choosing a location and species in each record. Post 11 of the other thread describes form design options.

If many-to-many relationship does not fit your data, then please clarify. Which of the relationships described in post 17 of the other thread fits your situations?