Back
Cannot update relationship value with every related data
I have 2 Tables. One for all Clients (Image 3) and one for projects the clients can create. The problem: I can only assign a handful of clients (Image 1). The rest is not visible for me nor can i assign it with the $id by just writing it into the relation field. It just get's gray until i refresh the page.
Second Problem: When i create a project with the specific client by hand in my web app i don't see any options for other clients anymore. (Image 2)
TL;DR
Issue: Unable to update relationship value for all clients in project database resulting in limited visibility and assigning restrictions.
Solution: Check on the database configuration to ensure proper relationships between the Client and Project tables are established. Verify that the necessary permissions are set for visibility and assignment of clients. Refresh the page to prompt visibility updates.