Sort Records Via Date (Newest first)

[tweety]

Hi

I have a form with subform. the subform has the date of sales, and the main form just holds and the customer details. My question is how and where do i set the records to show the newest sales first, i.e sort date.

thanks in advance

[orange]

Do you have a CustomerId field in the Purchase table?

You need to Relate Purchases to Customers.

Usually the model has Customers Orders OrderDetails and Products.
CustomerId is a FK stored in Orders


Can you show us your Tables and relationships as a jpg?

[tweety]

hi

i have attached a image of the table links, all the tables are linked, and the system can record sales and store purchased goods, the next step i would like to do is setup stock control.

thanks

[orange]

Have you linked masterFields (Customer CustomerId) and Child fields (Sales CustomerId)?
Have you sorted by Dates of Sales descending?

Can you tell us more about your Sales and Purchases and Suppliers?

[Missinglinq]

Maybe I'm missing something, here, but it sounds as if you simply want to sort the Subform by your date field, in reverse order. If this is the situation:

• Open the Form the Subform is based on in Form Design View
• Go to Properties - Data
• In the Order By Property enter: [YourDateFieldName] Desc
• Make sure that the Order By On Load Property is set to 'Yes'

You should now be set!

Linq ;0)>