Relationships

[Bobbyds1]

I have 3 fields linked in relationships when i open the first table and click on the + next to a field it opens the second table and displays all the info for the particular field and if click on the + next to an item in table 2 table 3 opens but does not show the information in the table it only shows the headings not the info. anybody have an idea whats going on

[Bob Fitz]

I have 3 fields linked in relationships when i open the first table and click on the + next to a field it opens the second table and displays all the info for the particular field and if click on the + next to an item in table 2 table 3 opens but does not show the information in the table it only shows the headings not the info. anybody have an idea whats going on

I assume that this thread is connected in some way to your last thread:https://www.accessforums.net/showthread.php?t=88070
It is much easier to help you if you answer any questions we might ask. It may also help if you could tell us something about your tables, how they are related and what you are trying to do with the database.

[mike60smart]

Hi

The little plus's alongside each record in the table are known as Subdatasheets and display any related data.

Seeing as you should never allow users to access tables in your database, these little plus's should be removed from View.

Relationships between related tables should be set in the relationship window.

If you need to see related data then this should be achieved by using a Main Form with a Subform for related data.

[Welshgasman]

Please do not crosspost your issue, and that includes in the same forum.
Stick to the one thread and then anyone can contribute to that sole thread. Duplicating post just ensures same advice is given multiple times, but in different threads.

[Bobbyds1]

here is an example of what im trying to do you will see no info appears in oem or replacement but info is in the table here is a screen shot of relationships

[Bob Fitz]

I believe your table design and relationships are wrong. We would need to know more about what the db is for to help with that.
Tables are for storing data. Not for adding/editing data. That should be done in forms which come after proper tables and relationships have been established.

[Welshgasman]

here is an example of what im trying to do you will see no info appears in oem or replacement but info is in the table here is a screen shot of relationships

Do not have the same field name in every table (EquipmentID) Do not have spaces in field names or characters like #, that is just making more work for yourself. You can have captions with spaces so the data looks better.

[Micron]

Agree with Bob. Consider copying, compacting, zipping and posting your zipped db. From the pic, it seems a parent record is about a filter and the sub record is about a roller, so I doubt you can relate any sub records which appear to belong to Belts 2.
My advice would be to stop any development for what you have because there are design issues and you will always struggle if you stay the course. Spaces and special characters should be avoided in all object names, but that's not the reason for what your posted issue. You might want to review db normalization too.