gregory.west Posted November 19, 2015 Share Posted November 19, 2015 I have three tables INVOICE, IDETAIL, and INVENTORYThe link between INVOICE and IDETAIL is INVOICE.ID --> IDETAIL.INV_NUMBERThe link between INVENTORY and IDETAIL is INVENTORY --> IDETAIL.PART_NUMBER'-->' is a many to one join. ie, each Invoice or Inventory item can have multiple IDETAIL records. When I try and create this join in the query builder I keep getting the join lines all moved about.Can anyone help here? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now