Ok so I have my xsd file and its importing with no errors but not behaving as I desire it too and I'm quite new to XML so I thought I'd request some help with this.
So I have a customer table which which will have an address in the address table (so gets an id from the address table).
I also have a site table which contain an address in the address table and link to a customer.
So My customer table has an customerid and a foreign address id.
My Site has an foreign address id and a foreign customer id and its own id.
My address table contains no ids to other tables.
Below is my current xsd file which inserts the addresses but fails to insert the customer and the site from my test XML file.