Skip to main content
Question

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

  • April 5, 2017
  • 0 replies
  • 95 views
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.
      This topic has been closed for replies.

      Can you clarify what you mean by this?

      "you would select the specifics of the asset
      • MCFNeil
      • Registered
      • April 6, 2017
      It sounds like you are looking to assign a piece of inventory (asset) to a client, even when the asset and client are made at different times, and not related.

      What type of "unique" identifier are you going to use to link the two?  

      At what point do they become linked?  What triggers the connection?  Is the asset sold from inventory?
      • MCFNeil
      • Registered
      • April 8, 2017
      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.
      Terms & ConditionsAccessibility statement