Thank you for the reply. I have added a couple of screenshots which show the child lookup table. I have also included the code from the original dffs that shows how the tables were linked.
Our parent table category has id, title
Our child table sub category has id, title, category (lookup to parent table)
I’m sorry that I’m asking such an obvious question.