So after sifting other forum posts and trying to find the answer in all the lessons I have purchased I am stumped...I confess I am relatively new at serious database design.

I want  one single table for addresses - AddressT. The addresses are different types (i.e. - mailing, billing, shipping, job site, etc.) and are intended to be used by ContactT, CompanyT, etc.. I have a PostalCodeT, an AddressTypeT, a StateT, a CountryT, a CountyT, etc.

My question is, how do I get all of the One-To-Many tables information to display correctly (which I have accomplished in other forms not requiring a junction table) once I have established the junction table AddressXAddressTypeT.

Your help is appreciated, I have a new customer waiting on this project.

---

Reply from Alex Hedley:

Create a Query in the Query build, drag on the Tables and make the JOINS between the AddressT to AddressXAddressTypeT then AddressTypeT to AddressXAddressTypeT.
Run it and see what you get.
You may get a cartesian product where you get multiple rows.