totalling records by job no.

[clmoss]

I have a database with a job number, a page number and a price for each record. So there might be multiple records with the same job number but different page numbers. I want to be able to set up either a new layout or a related database which will show only unique job number and the total price for all records for that job number. Thanks

[ August 06, 2001: Message edited by: clmoss ]

[Kurt Knippel]

Well, you could use a sub-summary report, but that would require preview mode, and you cannot do any data entry.

A relational database implementation would be the best solution. Jobs in one file and Pages in another file. You can then show the single Job record and Pages in a portal.

SUM ( Pages by JobNo::Price ) will show the total price for all pages for that job number.

[clmoss]

Sorry for posting in more than one section, I am a newbie and didn't know,consider hand slapped!

The database I have is for mail order catalogues and each record has the job number (i.e the magazine/catalogue) and the page number (e.g 2 and 3, 4 and 5, etc) which will be used on the shop floor, each record will have different costs but the accounts dept would like to see the total price for that catalogue. So the first option may work if you could explain it a little further because it's for viewing only and doesn't require data entry. The second option, I wouldn't really know where to start.

Thanks for your help.

[Kurt Knippel]

Start here for some references to training and/or books on Filemaker.

http://www.fmforums.com/ubb/cgi-bin/ultimatebb.cgi?ubb=forum&f=44&DaysPrune=1000&SUBMIT=Go

You can also look for book on relational database design at Amazon.com or your local bookstore or library.

Get an understanding of what Filemaker and relational databases in general are all about, then you will most likely be able to answer your own question.

[ August 07, 2001: Message edited by: CaptKurt ]