Deleting the data in the tables should not affect how the tables function / relate data. Not sure what is going on here... We could probably walk through the setup / configuration in a Teams call and I can see if I can determine what is happening. If this works, private message me with your email and we can set something up to walk through.
Hope this helps. Please accept if answers your question or Like if helps in any way. Thanks, Drew