Hi all,
This could get a bit long as I try to explain it, so I'll put the question out there straight way for those who already know what I'm getting at:
"Can I independently modify the contents of a child table which displays on a given parent page (view/edit/add) without changing the overall properties for that table?"
Now the lengthy explanation:
I'm currently building a program which will allow child records (eg: addresses) to be attached to records in a number of other tables. To ensure there is no conflict between parent_ids shared by more than one parent tables, I have added a field parent_type to the child table (addresses) and have inserted some before SQL code to ensure I retrieve only those records where type = current module.
I also have some admin/auditing fields such as created by/modified by/dates/delete flag etc which I would like to hide from the child table however I can't seem to find a way to hide them unless I remove them from the main table properties, limiting my ability to access this page to manually modify records.
So I'm looking to understand if there is any way to control the fields a given table will display as a child table independently of the way it will display as an independent table in a typical main view/edit/add page for that table?
I've experimented with using custom views however I'm concerned that this limits the flexibility users will have in terms of in-line editing due to the need to revert to the table's own edit page.
Any suggestions, ideas, or explanations on how the system manages these table views would be appreciated.
Cheers,
Aaron
