Using the same column twice for input

[Thomas_McIntosh]

Hi All,

I have data in two tables. One table of items, the other containing locations. The Item table contains a column with reference to the Location table, so Items can be organized by Location. Standard stuff.

I would like to be able manipulate Item records by their Location, that is: move Items from one Location to another either new or existing Location, or swap the contents of two Locations. 

My initial thought was to use a Form View of the Location table to pick two Locations from drop-down menus and then perhaps use an Action to modify the Location data of the related Item records, but the Form View doesn't allow the same column to appear twice - so I am obviously approaching this wrong.

Any suggestions as to a general method would be appreciated.

Many thanks!