AnsweredAssumed Answered

Move records

Question asked by FilipeTeixeira on Oct 4, 2013
Latest reply on Oct 4, 2013 by FilipeTeixeira


Move records


     Hey :)

     I've been struggling with something and well I think I've searched everywhere to find no solution.

     I have 2 tables. One with distributors, and another one with instruments. Each instrument is related to a specific distributor and a distributor can have several instruments assigned.

     What happens is that sometimes an instrument might be assigned to another distributor, already on our database. How can I change that? I tried to change the key field and the distributor name field but instead of adding it on a already existing one, it creates a new one.

     Any ideas on how to solve this?


     Thank you