Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What happens to a Parent / Child connection when I change the Index on the Child Table?

April 26, 2017child connection happens index parent Table

0

Posted

What happens to a Parent / Child connection when I change the Index on the Child Table?

1 Answer

0

Posted

Since the Index on the Child Table is essential in connecting to the correct Field in the Parent Table, resetting the Index-order on a Child Table will disconnect any Parent / Child connections made. Also, when you want to reconnect the Parent/Child connection, you must set the Index order in the Child Table back to the Field used in the connection in order to see the correct data. To Set Index Order: 1. Right click the Query for the Table you want to work with 2.