Skip to main content
Solved

Don't want created automatically field to show in origin table, but only destination field


  • New Participant
  • 1 reply

When I linked field data from table A into the field on table B, I noticed that there were fields that created automatically on table A. that linked with table B. How can I stop this action? I only want data from table A to show in table B.


Thank you : ))

Best answer by ScottWorld

Hide the field by right-clicking on the column header and choosing “Hide field”.

View original
Did this topic help you find an answer to your question?

4 replies

ScottWorld
Forum|alt.badge.img+20
  • Brainy
  • 8711 replies
  • Answer
  • May 16, 2021

Hide the field by right-clicking on the column header and choosing “Hide field”.


  • Author
  • New Participant
  • 1 reply
  • May 16, 2021

Thank you for your suggestion.

I have tried this solution before but i think it was not well organized and not neatly. It likes i have spam messages on my “hide view” tab. But anyway, thanks for your time and answering :grinning_face_with_big_eyes:


Nana wrote:

Thank you for your suggestion.

I have tried this solution before but i think it was not well organized and not neatly. It likes i have spam messages on my “hide view” tab. But anyway, thanks for your time and answering :grinning_face_with_big_eyes:


The relation is bidirectional so you get a new field in both tables to reflect that. Now you can get and show information from table A in table B, and from table B in table A.


The only option is to hide the field, as @ScottWorld said. You can create as many Views as you want, where every view has its own shown/hidden fields.


Your database may auto-create relationships check settings to disable link fields, like Top Mortgage Lead Generation Companies do for clean data.


Reply