MultipleObjectsReturned for ForeignKey

[Eccleshall]

Im having a issue where the I'm getting MultipleObjectsReturned error as there currently doesn't seem to be a way of using another field in the row to filter another foreign key by

Parent Child Relationship

Range
SubRange

Range
id name
1 Higer - male
2 Lower - male

SubRange
id name parent_range
1 Dad 1 (Higher - male)
2 Dad 2 (Lower - male)

Card
id code range sub_range
1 AB34 Higher - male Dad

sub_range currently throws the MultipleObjectsReturned 2 issue.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.