Having trouble creating relationships.

[qwerty]

I don't have a junction anymore. Area to Region is one to many relationship, and PlantID to LocID is one to one relationship. They connect to the location table, as a result it is doing what I want it to do. When I go to location, and click Nebraska, Iowa, and Missouri. It is only show the first record for each location, as if the rest is hidden. How do I make it show all the record?

Why did you edit posts to delete content?

1. build form/subform as described in post 11, option 2

2. build report

3. use Subdatasheet on table

[June7]

If it really is a 1-to-1 then don't need two tables. If it is 1-to-1 then there will be only 1 record associated from each table for each ID and only one record can show for each location.

Surely each species can be in more than one location and each location can associate with more than one species? If so, that is a many-to-many relationship and that requires 3 tables to represent the relationship.

If this is really a 1-to-many, meaning each species can be in only 1 location but each location can have many species, then you need to save LocID in PlantSpecies. And the link will be on primary key LocID to foreign key LocID_FK.

[orange]

ryder214,

Part of the purpose of a forum community is to share learning experiences and problem solving. By your deleting posts, you have rendered the thread practically unreadable. You may have found an answer/workaround to some symptom, but that is totally lost because of your editing.

Perhaps you could reconsider and describe to all what your "project is about" and what your solution was that caused you to mark the thread "solved".

Good luck with your project and future forum activity.

[qwerty]

I did exactly what June told me to do. I created a junction table, many to many relationship, and from my understand its for entering data. I already have data already enter. Why is the junction table blank? I need it to pull the data and organize it base on the location.

[June7]

The junction table is empty because you have not yet entered records that associate locations with species.

You need to be certain of the relationship type involved. Which of the types described in post 17 fit your situation?