Teeth history

[ictcrystal]

Hiya,



Im currently trying to create a way of displaying a history of the last 10 records of a customers teeth ONLY.

so to try and make myself clearer; basically im a dentist and to perform operation i need to be able to view a customers teeth history for the last 10visits.

So what i have ATM is a form that allows me to create new teeth entries however i would like it to allow me to click a button that shows the teeth history of that customer (BUT ONLY FOR 10 RECORDS- maybe this would require something that would stop the amount of records exceeding 10?)

I have a table that contains teeth id, customerID ,back teeth, front teeth and date ...

Please could someone advice with me with what to do or provide an idea...


p.s i will not b able to post up my current DB so im sorry if what i have provided is limited

[Missinglinq]

Base the Form you see on a Query. This can be done with a SQL Statement like this, as the RecordSource for the Form:

SELECT TOP 10 ClientTable.ClientName, ClientTable.DateTimeCreated
FROM ClientTable
ORDER BY ClientTable.DateTimeCreated DESC;

Replacing the Table/Field names with your actual names, and adding, in the Select part, whatever other Fields you need to see in the Form.

This will select the Top 10 Records which, since the Query is Sorted Descending by the DateTimeCreated field, means the Query will only return the last 10 Records created.

Linq ;0)>

[orange]

See this for similar http://www.access-programmers.co.uk/...d.php?t=275497

I realize this is only your second post here. However, the posts seem eerily similar.
When you post the same question on multiple forums, it is called cross posting. When you cross post,
it is considered proper etiquette to inform readers that you have done so.

The rationale for this is here.

[ictcrystal]

sorry for that i will not do it again