Hi, I have a linked field that links records from the same table but from a different view (I have filter applied on that view based on some conditions)
When I link a field (from Table A) to a record from another table (Table B), In Table B, I get a new column that shows what records are being linked to in Table A
But in my case, when I link to a view in the same table, I am not able to see what records are linked to a record in the view.
What I am trying to achieve basically is if a record from the view is linked, it cannot be linked to another record. I want to hide that record from the linking view. Please suggest if this can be done or if there is a hack for this. thanks in advance