James2169 asked
o1lab replied
Im struggling to understand what is missing.
Seems like you have created the relation correctly.
Parent A is associated with one child and Parent B in similar way
What are you expecting ? what is missing ?
So instead of manually adding each child to the parent using the GUI I expect to be able to infer the relationship from a field of ForeignKeys which in this case is called “Parent”
When I import the Parent table form a CSV I already have the ForeignKey information but NocoDB expects to to manually rekey it all in
And then after importing I can not select the LinkToAnotherRecord option either for the field
ah, you mean thsi for uploading bulk and creating relations with it
I understand that is important, but this is slightly tricky than it feels
hence the upload is in alpha
the reason being : this looked-up or related-field can come from any nested level
okay thanks at least I understand there are limitations now not just I don’t understand 
I expected to be able to just type in or paste into the ForeignKey field without the manual GUI selection process
i think it’s important to not that defining links from child to parent doesn’t behave in the system as a valid foreign key, since the child key can only be use by one parent (exclusive). this is not a behaviour expected from a foreign key