I have a ‘Cellar’ form that holds details of current and previous wine purchases. It is linked on a ‘one to many’ relationship with a ‘Bin’ form that records the bin locations for the current stock of wine bottles (one location / bottle). As an example, to withdraw a bottle, I unlink bin location 7D which is displayed in the window within the Cellar layout. However, the 7D bin reference does not disappear, but the adjacent bin reference 7E does disappear. Looking at the Bin form, the record for the intended bin number 7D correctly shows an empty wine name field, but the bin number of the adjacent record 7E has been changed to 7D, duplicating the ’empty’ bin number.
I attach screenshots of the relevant part of the Cellar view after the unlink action and ‘before and after’ extracts of the relevant Bin records. Why is this happening?
Attachments:
You must be
logged in to view attached files.
Hi Martin,
Could you please email me an archive of your parent form so I can test it out here?
If you switch to a different parent record and back, does it update the view properly then?
.
