Select records based on group by condition

[renev]

I have a table which containes fields such as partnumber, supplier, price etc.

There can be same partnumber with different supplier and different price. How can i fetch records of those parts with minimum price?

I have included a summary fieled 1 which is minimum(cost) and another calculated filed 2

GetSummary(1;PartNumber)

I get all records with field 2 i get the currect minimum cost per part number.

But how to omit other records?

My script steps are

Go To Layout

Enter Find Mode[]

--I have few conditions here

Perform Find[]

Sort Records based on part number

[bcooney]

I'm just about to start a project that has price levels based on qty, by vendor. Here's a bit of a proof of concept I've been playing around with. I've allowed entry into the portals for new records although in the final product I will have buttons for new records.

If anyone can tell me a better way to do this, I'm all ears. I can see that the SupplierID in the POLI table is not evaluating correctly to give me the cost, perhaps a commit problem? Again, I wouldn't run into this with scripted buttons, but I am curious as to why this happens and what a better approach would be. Thanks and hope this helps the OP get started on a purchasing system that has price levels by vendor. From what I've read in your post, you don't have all the tables that you might need.

Topic_194494.zip