How to delete/edit a record where a field matches a value?

  • 1
  • 1
  • Question
  • Updated 2 years ago
  • In Progress
I have an app where clients (non users) are the parent table and their assets are the child tables and everytime a client is created related child records are created with no asset detail. That occurs because that part is done further on and by other people, according to their functions. Although, we control assets without clients assigned also. And I want to create a button for assignation where you would select the specifics of the asset and any record that has no client and matches the specfics would be assigned to the client. So there wouldn't be a inventory issue due to duplicate records. If there is also a way to automate the process that would be ideal.
Photo of PatriciaSabelli Fabbri

Posted 2 years ago

  • 1
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,698 Points 20k badge 2x thumb
I'd recommend creating a joined table.

Basically you will have a "Locker Assignments" table.  Each Client has many assignments AND each Locker will have many assignments.

Then within the assignment you can have start and end dates, and easily be able to tell if a locker has an "active" assignment.

That will also drive your reports and drop-downs for "Available" lockers.

Then you will also have a history of locker assignments, whereas right now it looks like you lose that when you change the current dropdown connection.