Could you give us a little more information on what data you are working with?
I'm having a hard time visualising what you are trying to do.
Tell me the steps you make. Maybe we can come up with a more practical way to do this.
In the Stock table create a new global field, gStockToFind. Make it of type 'text'.
Create a self-relationship from the Stock Table to the Stock Table, as:
gStockToFind = BundleNumber
Create a script:
Go To Related Records (Using The Relationship you just created) ; on Layout [Stock List] ), match current record only
Put the global field on the layout, enter the list of Bundle Numbers as a return-separated list, and hit the button with that script attached to it.
Wouldn't it be handier to be able to add products to a list and to be able to see immediately how many you still have in stock?
Kind of like a balance sheet. Where you have stock added (+) and stock sold (-) and a total calculated to show how much (if any) you still have in stock.
I realise this might mean a rather big change to your system; But it seems to me the way you are working now might not be the most practical way.
Here is what I had for my script.. Like I said, messy as heck.
Move/Resize Windo [Current Window; Height:600; Width: 150; Top: 0; Left:400]
Go to Layout ["Picklist"]
Enter Find Mode
Go to Record/Request/Page [First]
Go to Layout [original layout]
Adjust Window [Maximize]
The way I'm trying to get this to work, is instead of using all these new record requests in the find mode, is something along the lines of this:
Bring up a dialog box, asking for how many bundles I need to look up..
then bring up just that many find requests, kind of like a routine similar to this:
Input "How many records to search for?";
reply = count
for requests = 1 to count
if requests = count then goto continue
return to original layout
i know ugly scripting, but I just woke up and havent plugged into the coffee pot yet lol..
The overall reason for this script is, we generate picklists for the office, so that they can use the information to do all the billing, and the data we give them from this picklist is the bundle#, heat number, trailer it came in on, gross weights, net weights, etc... where when we pick the materials to send, all we need to have is the bundle#'s, type just these into the search. and it will then pull all the records up of these picked items. It will also notify us if the records that come up are short a bundle or two that we made a mistake on our end of a written down number so we can double check that particular bundle(s) that are not found. So we can make sure we might have transposed a number, or it was not entered into the system to begin with.
Thanks for the help,
How about this:
This is just a basic example of the find you wanted to do. I don't know if that's enough, or if you want to de a larger overhaul of your system?
It sounds to me like you need to do a lot of manual entry (Do you need to imput a bundle number into the found items?
Ans the find is also a pretty temporary thing, there is no record of previous finds, etc.
I still don't have a clear picture of your system, but maybe the find is all you need.
Let us know what you think!
I really appreciate all the help. Will look at these examples and see what happens. What hurts me is I havent messed with Filemaker in about 4 or 5 years for detailed work. I've done a few simpler databases over the years, but I've forgotten more than I recall nowadays, having started with FM Pro back when V1.0 first came out for Windows. So, of course, over the years some actions have been changed, renamed, overhauled, etc., so now it's a matter of having to re-learn everything again. In fact I just downloaded some theme packs and graphics and found a decent theme I will use once I get the system the way I want it to work. And of course, working with FMPro Advanced 11 now, I just get handed V12.. (Shakes my head) Oh well, I'll get caught back up one of these months.. Sitting here going through a few Filemaker 11 books and trying to kick the cobwebs loose and recall how to do more things with it.
Thanks again, and I will let you know if I have any more success with your suggestions. Granted, what I have works for the most part, I just know that there has to be a simpler way to accomplish what I was trying to do was all.
YES!! That last demo you posted, DaSaint was just what I was trying to do, on the find! Thank you so much! I can take that and work from it. Thank you so much! That looks a whole lot better than what I was using. It is greatly appreciated!
I'm glad we got there :)