OK... not to sure on this.......

You have table 1
...... CHAIRS..... Chair ID (Autonumber), Chair details (anything you like)

You have table 2
...... LOCATIONS.... Location ID (autonumber), Location details (anything you like)

You create a 3rd table
Cross check.... Location ID and Chair ID (both = number)

THEN you link table 1 and table 2 up with table 3 (make sense?)
Then you create a querry based on Table 1 & 2..... make the querry a create table querry or something.... ?

Now create forms for Table 1 and table 2..... must make it so that new records cannot be entered... only current records can be editted... this means that people can look up the chair number they are taking, and enter where it will be going!

now, when people run the querry, they can see the latest results ???

Of the top of my head... that should be right! No promises though!