I have a custom Choice column used on a few tables, which needs to be removed (not used)
On every table I have removed the column/field from all views and forms.
However when I try to delete the column, I cannot due to a relationship dependency. Although no dependent table is displayed.
Why would a relationship depend on a Choice column? And how to resolve in order to delete the column?
In my case there is a choice field called Fund which is the no longer required (a Fund is a pool of funding which has a particular focus).
A choice field Fund has been added to on two tables
- a Projects table (each project is for a particular Fund)
- an Allocations table (details of the funding allocations to Projects).
This table also happens to have the Fund choice field, in other words a funder will specify their Focus or Fund which is stored when an allocation is created.
The Allocations Table also has a lookup column for selecting the relevant Project which has created a relationship (each allocation is for one project and one project can have many allocations).
When I try to delete the Fund choice field from the Allocations table the dependency lists the 'project' entity relationship although no dependent table is shown - see clip below
If I view the above relationship under the Relationships screen, it is named 'Projects' so I am concerned that deleting this relationship will delete the required lookup and relationship with the Projects table.
Similarly when I try to delete the Fund choice field from the Projects table a dependent relationship is also shown as preventing the delete - see clip below:
The wierd part is why would a choice column have a dependent entity relationship?
