[TYPO3-dev] Re: Relations in TCA by not uid field.

[David Bruchmann]

Hi Dmitry,

I haven't any xp with circumventing or replacing the uid-field but here are some ideas:

* rename the ID-field to uid

* add an uid-field (with auto-increment like in common TYPO3-tables)

* create a view for the table and map your own a field uid to your own ID-field, this article explains that: http://xavier.perseguers.ch/en/tutorials/typo3/articles/indexed-search-crawler.html#c895
but consider that the article is already a bit old-
In your own TCA of the table you posted you've to use then that of the view.

* use filters: https://docs.typo3.org/typo3cms/TCAReference/ColumnsConfig/Type/Group.html#filter
No concrete recipe yet, how that could help ...

* if you are able to import the "foreign data" only from time to time you can use the extension external_import

Best,
David