I am trying to create a relationship between two databases that allow assets to be signed out like so:
Assets: RED BLUE GREEN
People: TOM SAM SARAH
Any asset can be signed to any person, but only once. I have managed to get the one-to-many working, but I can sign the same asset to TOM, SAM and SARAH at the same time. Once it is signed back in, it can be allocated to another person.
How would I go about setting up so once it’s assigned to someone, it disappears from the available list? Then reappears once it is returned?
I don’t really understand a lot of the logic in Adalo yet, I’m used to writing expressions that are mathematically logical, so this is different for me.
Thanks for all your help =)
My next task is to get the assets returned at the end of the day, I’m halfway there, they can be removed with a single button, but they never reappeat in the list. I’m getting something wrong with the relationships I think, as they appear as ‘Untitled’ in the database if you use the delete function.