Hi,

I have a query that is made from three tables. The query looks like the following:

tblPriceList.Description

tblSupplyOrderInvoiceNumber.InvoiceNumber
tblSupplyOrderInvoiceNumber.Vender

tblSupplyOrders.InvoiceNumber (related to InvoiceNumber in tblSupplyOrderInvoiceNumber)
tblSupplyOrders.Description related to Description in tblPriceList)
tblSupplyOrders.UnitOrdered
tblSupplyOrder.Date
tblSupplyOrders.Cost



When I include all three tables in the query, no records are displayed, although I am expecting 17 test records to show. However, when I include tblSupplyOrdersInvoiceNumber and tblSupplyOrders by themselves, the records are displayed, but the contents in the tblSupplyOrders.Description field displays as a number (The record number) and the not the full text. The full text of what I want to show is in tblPriceList.Description, but when I add it to the query, I do not get any records.

I hesitate saying for sure, but I believe that I have the relationships set properly. In the Relationship window, the relationship line between tblSupplyOrderInvoiceNumber.InvoiceNumber and tblSupplyOrders.InvoiceNumber show a one to many relationship. However the relationship line between tblPriceList.Description and tblSupplyOrders.Description does not show the symbols 1 to many(there is only a straight line), but when I open the edit window, it says one to many. Does this matter?

Thanks in advance.

David Tolson

Do you have foreign key constraint between tblPriceList.Description and tblSupplyOrders.Description? Did you check for NULL values in field?
If you're not checking for NULL it can be cause.