<div>
I figured that's what it was but just wanted to double-check. I'll just create a query with both tables in it. Thank you for the quick response. Appreciate it!
</div>


I figured that's what it was but just wanted to double-check. I'll just create a query with both tables in it. Thank you for the quick response. Appreciate it!

<div>
<div class="content wysiwyg-content">
I have 2 tables that have a one to many relationship set up in the backend DB. They are also set to enforce referential integrity, cascade update related fields, and cascade delete related records. When I open the main table in my frontend in datasheet view I do not see the little plus signs to expand the subdatasheets for the linked table. I only see this in the backend DB. Is the plus sign not used or not able to be used in the linked tables in my frontend?
</div>
</div>


I have 2 tables that have a one to many relationship set up in the backend DB. They are also set to enforce referential integrity, cascade update related fields, and cascade delete related records. When I open the main table in my frontend in datasheet view I do not see the little plus signs to expand the subdatasheets for the linked table. I only see this in the backend DB. Is the plus sign not used or not able to be used in the linked tables in my frontend?

Table Relationships for Linked Tables

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.