Our Preferred 5 Star Hosting Provider - Award Wining FileMaker Pro Hosting
Results 1 to 3 of 3
  1. #1
    FREE Member
    Join Date
    Oct 2012
    Posts
    2
    Downloads
    0
    Uploads
    0

    Creating an Organized List

    Good Afternoon,
    I am attempting to create an stock availability list off of my inventory. I have been able to create lists but the lists are unorganized.
    The list needs to include the following and be able to generate on command:
    • Count/Combine like inventory items based on two size measurements.
    • Exclude items with no associated price.
    • Exclude data not needed by customers.
    • Display items in a logical organized manner


    Thanks for the help!
    Warning: This is an Old Thread
    This discussion is older than 420 days. information contained in it may no longer be current

  2. #2
    Senior Moderator - FMT Preferred Developer Consultant - West Coast USA - Global Techphan's Avatar
    Join Date
    Mar 2006
    Posts
    2,268
    Location
    Southern California
    FileMaker Version
    FM 9 Server, FM 10 Server, FM 11, FM 11 Server
    OS
    Windows & Mac
    Skill Level
    Intermediate
    Downloads
    0
    Uploads
    0

    Re: Creating an Organized List

    The list needs to include the following and be able to generate on command:

    Count/Combine like inventory items based on two size measurements.
    I am sure that many of us here will be happy to offer advice, but you will be doing the programming with a little guidance from the answers to your post(s). You will have to decide what works best for you.

    You want to "Count/Combine like inventory based on two size measurements. We need a little more detail here. Are you dealing with men's shirts with a neck and sleeve length? Or lumber in a lumberyard? Or...? Are the number in numeric fields or textual data?

    You can find records by two basic methods:
    1) Two global fields (to store the two measurements) and a find script using the measurements placed in the global fields;
    2) A portal with the two global fields "programmed" into the relationship between the two tables with a portal teasing out the child records that meet both of the requirements.
    3) A count can be derived in either of the above methods.

    Exclude items with no associated price.
    Easy. Find all records with price field > 0.

    Exclude data not needed by customers.
    Very subjective on this one. Who makes this decision? Is a customer going to sort through your records and place a check in the box of any item they want to see?

    Display items in a logical organized manner
    This is the most subjective. What are you displaying? A list of items? Pictures? And, without intending to be offensive, one person's "logical and organized" may very well not be logical and organized to another person. This is up to you based upon what you want your employees or customers to see when using the database.

    I think you will find FileMaker to be both extremely rewarding and also extremely frustrating. Welcome, and let us know how we can be of help along the way.

  3. #3
    FREE Member
    Join Date
    Oct 2012
    Posts
    2
    Downloads
    0
    Uploads
    0

    Re: Creating an Organized List

    This inventory will help track nursery stock (trees). Two measurements are the height of the tree, and the size of the tree trunk. When referring to information the customer does not need, company management is making that decision. It in only omitting one area, which is the physical location of the plant.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 02-18-2011, 02:15 PM
  2. Keep Serials Organized?
    By tmas73 in forum FileMaker Pro 9
    Replies: 6
    Last Post: 11-26-2008, 07:35 PM
  3. Creating records from a list
    By Glorifindal in forum FileMaker Pro 9
    Replies: 6
    Last Post: 10-07-2008, 07:27 AM
  4. Creating a Conditional Value List
    By Ratmslasher in forum FileMaker Pro 9
    Replies: 2
    Last Post: 08-22-2008, 08:27 PM
  5. Creating a conditional value list
    By adricey in forum FileMaker Pro 9
    Replies: 0
    Last Post: 08-07-2008, 09:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Welcome to the Original FileMaker Forum
With designated forums for almost every FileMaker topic...FileMaker Today is a free-to-join community where you can boost your FileMaker expertise, build better solutions and solve your technical challenges. If you're building FileMaker solutions, this is the place for you.
Follow FMT
We Are FMT
FMT is home of The World's leading FileMaker News Site, Worldwide Developer Directory, FileMaker Connect Community and so much more.