First In/First out

[bobwhallz]

hi. I an new using Filemaker (2months). I have a small shipping database i built for my small business. I would like to be able to track my shipment. I want to check in items and check them out. However i have no idea on how i could proceed. I need help with your guidance so i can build that option. Or if there is a tutorial like that i would like to learn from it. so I want to display maybe in a protal a list of all checked in items with a check out option. when i click on check out, the item is removed a placed into the check out portal. the catch is the item can only be checked out if it is on the first position. if there is an item that precedes it , i would like to show an error message.

i need your help i am really new at this.

Thank you

 

Bob

[Lee Smith]

Hi Bob, and welcome to the Forum,

 

I moved your topic from "Tool Tips" to "Managing Scripts”. Because the Tool Tip is a Tool commonly used in your interface. For more information on it, see your help.

 

Your topic could have been posted in anyone of several Topic Areas, but it seems that you will need to script part of what you are wanting to accomplish.

 

If you have any questions about action, please contact me by Private Message.

 

Lee

[LaRetta]

Hi Bob,

 

Since you have a portal of the items for sale, in their natural creation order of when added originally then all you need to do is display only a SINGLE portal row.  Do not sort the relationship nor the portal.  When the User clicks the single row, they are selecting the oldest product always (first related) and they can 'proceed with checkout.'

 

In this way, User won't get in trouble and resent the program since you are protecting them from making a mistake to begin with.  :-)