AnsweredAssumed Answered

Processing a list of records to create an inventory

Question asked by eiton on May 13, 2010
Latest reply on May 13, 2010 by eiton

Title

Processing a list of records to create an inventory

Post

I'm using FIlemaker Pro 11 on Mac OS X.

 

I'm trying to take a my database which has a list of cards with extra information such as condition and price and turn it into something which I can print out.

 

The important fields in the database for this are:

Name (card name)

Condition (card condition)

Price (price on the specific card)

 

Now there's multiple copies of cards in different conditions. You might see two entries of "card a" in good condition and one of "card a" in poor condition. I want to go through all those records and create a list broken into groups by name then by condition with a count of each.

 

Basically, I'm  trying to take records which look like this:

 

Card A - good - $2

Card A - good - $2

Card A - bad - $1.50

Card B - good - $5

Card C - good - $3

Card C - good - $3

 

and make it look like this:

 

Card A - good x2 - $2

Card A - bad - $1.50

Card B - good - $5

Card C - good x2 - $3

 

Just to be clear, I don't want to change the table the original records are in to have a quantity listed or anything. I want to take all the information from the table and output it as a list which looks like the example.

 

I've been scratching my head trying to figure out how to do this exactly just using filemaker.

 

I just need the output to be in a plain copy and pasteable format.

 

Those are all the important details I could think of for this problem.

 

 

Thanks ahead of time for any help,

Bryce

Outcomes