Creating new records

[Benny1973]

Hi

I wonder if anyone can help. I attach a table that is a material list (27000 records). When I add a new material I want to be able to see the last part code I created for a particular supplier.

For example C001, C002 and C003 are for a supplier company called Chapters so I would scroll through the combo box search list in the form for the last one and create a new record called C004. The problem is that E00001, E00002 for a company called Edwards supplies 20,000 items so it's a long way to scroll through to create a new part code called E20001. How can I show in the form what the last part code is for each Supplier?

I attach the form and table as I'm not very good at explaining this, although I have had to delete approx 20000 records as the database was too big to be posted. Any advice/help would be greatly appreciated, many thanks

 

[scouser]

Filter

Hi 'Benny'. A simple answer (no coding required) is to Right Mouse Click within the 'Part Code' field and enter the Prefix of interest i.e. P as the filter criteria (see screen dump). This will return ALL parts that begin with P. You can then navigate to the last record with a single click using the record selectors at the bottom of the form.

Not perfect, sure something could be coded (but I am a useless coder! ).
Phil.