Unwanted Other... link on Edit page

[John3136]

Hi all.

I've just added a new Table to my application with a few grafted fields.

In fields.ini I use a vocabulary to show some of the grafted fields instead of a TeamId

When I hit "Edit" on a record in the table It displays the results of the vocab correctly, but then after it is a link labelled "Other..." That takes me to a page to create a new Team.

- I don't want to be able to create a new team from here or even edit the team id !

I've got permissions set up so the field isn't editable (which seems to work) but I assume there is some other permission I need to take away to remove the "Other..." link ?

Thanks.

[John3136]

Looks like the issue is in DataFace/FormTool/select/php

In 3.0.3 line 83 we're in a vocab and we're looking at the "Other" table in the vocab (in this case "Teams").

On the actual Teams table users are allowed to add a new Team, but in this context I don't want them too.

Still working on an actual solution to my problem...

[John3136]

I think I've worked around the issue. 

I created a view that does the mapping of my TeamId to the text that I want to see instead of just the number.

That simplifies the grafting in __sql__ - I just need a ClubId for a security filter.

The vocab for the TeamId is simplified to SELECT TeamId, TeamTextFROM TeamNames

...and I don't get an "Other.." link.

[John3136]

Nope. I've still got a problem.

Even in a simple table with no grafted fields etc I still get an unwanted "Other.." link

Looks like I need to mess with permissions somehow or edit the Xataface source to never add the Other link (I never want it !)