Hi to the Community,
My issue concerns 2 tables, which are linked to each other :
- Objects (art pieces from an art gallery)
- Transaction : when a client buys one or several of the art pieces, I create a transaction. One of the field of this table is a linked record to the “Objects” table. Therefore I select the different objects bought by the client in this table.
What I’m trying to do is the following : let’s say the client buys Object A and Object B. I would like to automatically update the field “Status” (which is a Single select) in the “Objects” table for BOTH of the objects to “Sold”.
I tried many different things but it seems like it doesn’t work when multiple objects are selected…
Any chance someone could help ?
Thanks a lot !