Reports for products of same type
I’m looking to do a report of products within an assembly.
Say we have a door set with frame, door, hinges, locks, glass etc.
Within the job we may have more than 1 assembly which may mean we have more than one type of lock per Job. So rather than having 10 locks of the same ID, I wanted 1 line stating 10 number of the same lock. Can filemaker handle this through the normal report editor or do I need to do something different.
I want to have only one line on the report for each type of lock with the job.
Job No 379
That would depend on the design of your database, but yes a summary report can produce one line of data for a group of records with a common value such as a product ID or product category.
See this thread: Creating Filemaker Pro summary reports--Tutorial