All records are not being displayed

[jon jomaco]

Hi,

- I had a form where orders are shown and a subform within it where products can be selected for these orders as desired
- All the records were displayed in the form

Now i added another subform where the orders can be assigned to certain customers. This form works fine and the values which link an order to a customer are put in the link table correctly etc.

However, now:

- All records (orders) do not show
- The records which do show are those which have a link to a customer

I don't see where i have gone wrong. Upon unassigning a customer from an order, via removing the link between the order and the customer by deleting the record in the 2nd subfrom which i put in, the order is still shown when going to the next record and going back etc. but when the form is closed and reloaded the order is no longer displayed. Therefore this is why i have come to the decision that it has something to do with the link not being present.

I hope that someone can help me to derive a solution as to how i might ensure all the orders (records) are shown independant of whether or not they are linked to customers, any information appreciated.
Cheers,
Jon.

 

[GolferGuy]

Jon, showing us the SQL being used to supply the records for this form that is not showing you all the records would be most helpful. In the meantime, try looking at including all records from the orders table, and include records from the customer table only if they are present. If you double click on the line between these two tables in the query design view, you will be presented with a dialog box that will allow to make this choice.