Winterwolf73
New member
- Local time
- Today, 04:08
- Joined
- Jul 3, 2020
- Messages
- 26
HOLY CRAP guys. When you give information, you GIVE information. I love it. All of the info y'all have given me is great. However, it still does not answer my question. Let me try asking it a different way.
If I am understanding this correctly, the Join Type button in the Edit Relationships really only applies to queries. Though if this was the case, I do see why the developers would put that option here.
In this case, I have one customer that has many orders. I am looking to link the Invoice Number (from tblCustInfo) to the Invoice Number (in tblInvoices). I have a good grasp on how to get this far. However, what I am not sure about is the Join Type. Let me give you what I think the different properties mean, and you can tell me if I am completely off base.
Option 1 - this would pull only the records where both fields are equal. (pretty self explanatory).
Option 2 - this option would include all records from tblCustInfo that matched the field from tblInvoices.
Option 3 - this option would be the same as Option 2 but in reverse order.
So if I wanted to pull all invoices from Customer 1, the easiest way to do this would be to add a field in tblCustInfo (called CustomerNumber) and use Option 1.... correct?
What is confusing me with all of this is exactly how Options 2 & 3 work.
If I am understanding this correctly, the Join Type button in the Edit Relationships really only applies to queries. Though if this was the case, I do see why the developers would put that option here.
In this case, I have one customer that has many orders. I am looking to link the Invoice Number (from tblCustInfo) to the Invoice Number (in tblInvoices). I have a good grasp on how to get this far. However, what I am not sure about is the Join Type. Let me give you what I think the different properties mean, and you can tell me if I am completely off base.
Option 1 - this would pull only the records where both fields are equal. (pretty self explanatory).
Option 2 - this option would include all records from tblCustInfo that matched the field from tblInvoices.
Option 3 - this option would be the same as Option 2 but in reverse order.
So if I wanted to pull all invoices from Customer 1, the easiest way to do this would be to add a field in tblCustInfo (called CustomerNumber) and use Option 1.... correct?
What is confusing me with all of this is exactly how Options 2 & 3 work.