This is probably a basic questions on junction boxes but I need to ask anyway. I have created a junction box with Owners and Sites. I have formed relationships in the junction T with the Owner IDs and Site IDs. When I do a Query to get information from the OwnerT and SiteT, I bring the * in for the Owner T and fields from the SiteT. However, when I run the query, there is no information about the Owners or Sites.
My question is, do I have to physically input information again from the OwnerT and SiteT so that the OwnerSiteQ will show the information?
Reply from Alex Hedley:
You have OwnerT info and SiteT info In your JunctionT you will need OwnerID and SiteID so 1 | 1, 1 | 2 etc then in your Query join OwnerID from OwnerT on OwnerID in JunctionT and the same for Site
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Expert 8.