Here your app with the item fixed. I created a Calculation to Get Next Month and then another to compute the shipping month. Add relationship and a summary field to count the items.
http://www.filemaker.com/11help/html/create_db.8.2.html#1027557Home > Designing and creating databases > Creating a database > About planning a database
A well-designed database promotes consistent data entry and retrieval, and reduces the existence of duplicate data among the database tables. Relational database tables work together to ensure that the correct data is available when you need it. It’s a good idea to plan a database on paper first.Follow these general steps to plan a database:
Relational Database Design 101 (part 1 of 3): Designing a Flat File Database
Relational Database Design 101 (part 2 of 3)
Relational Database Design 101 (part 3 of 3)MY STANDARD LIST OF FILEMAKER LINKSThe White Paper for FMP Novices is useful -
Filemaker Free - Listing of free resources -
Free unlocked templates
By Richard Carlton Consulting
Starting Point - Contacts | Accounts | Calendar | Estimates |Invoices | Projects |Products | Staff etc.
Donations - Accounts | Contacts | Donations | Reporting | Prefs
Data4Life - Contacts | Calendar | Projects | Prospects | Journal | Goals
RCC Blog -
By yzysoft.com Contacts | Products | Invoices | Letters
Sample Database -
A free calendar is available and can be integrated into your database
Seedcode Calendar Free -
Filemaker's Online Help Pages
FMP 12 http://www.filemaker.com/12help/index.html
FMP 11 http://www.filemaker.com/11help/index.html
FMP 9 http://www.filemaker.com/9help/index.html
Hints, Tips, and Demo Downloads FMP version 6 thru 12
FMP business database demos - some are fully useable
The Excelisys Business Tracker V3.0 -
Filemaker released a FMP runtime database in 2007 for students called "Campus Productivity Kit" and is available online, notably at CNet
Google "Campus Productivity Kit" https://www.google.com/search?q="Campus+Productivity+Kit"
WIN - http://download.cnet.com/FileMaker-Campus-Productivity-Kit/3000-2124_4-10577579.html/
Mac - http://download.cnet.com/FileMaker-Campus-Productivity-Kit/3000-2124_4-10577567.html/
You can rename the database from a .usr file to a .fp7 file and open in FMP 7 thru 11
Lynda dot com has Filemaker Videos (portions are free)
YouTube - Filemaker Videos
UK FileMaker Channel
FileMaker, Inc. Channel
Lynda.com Channel - Filemaker videos
Dwayn Wright's Channel
Soliant Consulting Channel
Filemaker Academy Channel
Skeleton Key Channel
Accelerate Computer Training Channel
Filemaker NewsScoop.it is an information curation site - free option available.Filemaker Info - http://scoop.it/t/filemaker-info
Filemaker News - http://www.scoop.it/t/fm-news
Filemaker Wikipedia -
Filemaker - Version By Version -
Search specific Filemaker sites with this Custom Google Search
Hi S Chamblee,
Thank you for your prompt reply and fixing my database I appreciate it, I tried to import our files from excel and I noticed our records for the past Past years (November 2007, November 2008, November 2009, November 2010 & November 2011) to input future years (November 2013) and it also included future years (November 2013) because I also tried to input. kinldy help me also to fix this one. Thank you very much.
Your links are very useful. thank you very much.
Here I am again appealing for your help regarding my above query. Thank you.
Can you make that a specific question?
You listed more than one issue at the start of this, exactly where has the car run off the road for you?
Sorry. I didn't notice you had another question. Took me a little while, what you were saying but try this update. It only show the records for the next month of the current year.
I will make a another update later tonight when I have time. To fix January shipments.
Hi S Chamblee,
Thank you very much..."I believe this will do what you need"..Big Yes!..thank you so much...