Location within a location

[Teady91]

Hi all,
First i would like to thank every one for the help they have given me so far, i have solved quite a few bugs in my design with the help of this site, cheers every one!

Now my next problem has to do with asset tracking.

The company i work for does alot of construction and looks after many sites around the place. on each of these sites we have some shipping containers which we use as workshops. what i want to be able to do is track all the tools that are in each container.
Ive uploaded a cut down copy of my data base, it just has a bit of jiberish data in it.. for testing purposes.

It is working fine at this point, what i want to happen is when i enter the container, the site automatically updates. im not sure if my table relationships are correct that is why i put this post in the table section, but it is really a general issue...

The other problem is on these sites we have some assets such as vehicles and machinery that arent tied to a container, so i want to be able to just have them linked to the site.

all suggestions would be much appreciated!

Cheers,
Taison.

 

[Teady91]

I forgot to say, that i need to be able to move all the assets in a container when that container is moved. with out having to go through and update each individual asset.