I have 2 lists Child and Parent inside a SharePoint online site, where the child list has a lookup field to the parent list. Currently the parent list has 8,000++ items as follow:-
so now when i create a new child record the parent lookup field will show this error:-
This is a lookup column that displays data from another list that currently exceeds the List View Threshold defined by the administrator (5000).
so to overcome this error is it fine if i remove the parent lookup field from the child list, and just store the parent id inside a numeric field?
Any idea on this please?