with the foreign key field there seems to be a restraint on using the id as value and text, see attached.
I cannot see a reason for this and it would be useful if it could be removed as it will allow me easier filtering of data and it would avoid me having to create a view for this. Just text searching on an id is a work around it would be easier if I could filter on the ID of the foreign key, is there a special reason this cannot be done?
Wir verwenden eigene Cookies und Cookies von Drittanbietern, um Ihr Nutzererlebnis zu verbessern und Ihnen einen optimalen Service zu bieten. Wenn Sie die Website weiter nutzen, gehen wir davon aus, dass Sie mit unserer Cookie-Politik einverstanden sind.