How can i make my 60,000 thinner?

[Spanner_east]

I have a company master file with 100 companies.

Every company has 3 copies of the 200 CDs we produce as their stock.

I also have a sales file with sales details file attached via a portal.

I want to show the companies stock with the sales subtracted but am unable to think of how to show their consignment stock. Showing each company_cd number to show the results would equal over 60,000 records?

how can i slim this down?

[QuinTech]

Tough to say without knowing just what you're trying to do. Are you trying to get a feel for how well each CD is selling? Trying to analyze who you need to restock? I mean, yes, if you have 60,000 CDs, then viewing every one of them will give you 60,000 records. But think about why you want to show those records and what you hope to learn from looking at them.

Jerry