Adding removing related records in subgrid

(1) Share

Report

Posted on by barryjarvis

I have experience of using a subgrid to show related records on a form. However, only when there is a lookup field on the related record.

I want to link Customer Assets to the Agreement by way of a subgrid (i.e. a subgrid on the Agreement showing Customer Assets that are covered under that Agreement).

Is it possible to add/remove Assets to/from this subgrid without the use of a lookup field on the Asset pointing at the Agreement?

I know I'd have to set up a relationship, but not sure about the add/remove solely from the subgrid.
Note that when removing from the subgrid i don't want to delete the asset from the system, just remove the relationship to the Agreement.