Ryan P

Sorry for the long absence from these forums, it seems holidays will do that… Anyway, I wish to filter the portal. For example, the main record is for workers, and each worker will have a number of wrenches and gadgets displayed in a portal, and I want to filter that portal to only display wrenches when I run a script. Thanks for your help

I couldn't seem to find any topics that already addressed so sorry if I'm repeating a topic. Just a quick question, I have a portal with several records and I tried to make a script to filer those records and it didn't seem to ever return any results. Then, I tried doing this manually with the find button and still perpetually receive the no records message. So is it possible to perform a find inside a portal? If so what is the best way of doing so and can I automate it using a script?

Thanks very much that works perfectly now.

I'm aware of that, I don't intend to show the result of the find, I intend to sum a certain field in both tables and compare the two values...

Thanks that worked great, one more slight problem though, is that I need to perform the same search on two different tables so can I do this without have to the user re-enter the date using the method you outlined?

I'm not quite sure how to do this in a script however. In the criteria I have tried both */*/<> and just <> but it comes up with an error stating that the field should be in the range 1 to 4000 and has to be in date format. I also tried doing this with a variable */*/$y but still to no avail. Is there any other way I could do this?

Hello, I've run into a frustrating problem. I have a custom dialog box which appears in my script and the user inputs a certain year. What I want to do is then perform a find on a date field and just keep the records that have the same year as was inputted by the user. I what to have the set the satisfies the calculation Year(dateField)=input However, the find function does not seem to let me do this... Thank you in advance. Ryan

Thanks that worked great! It all had to be in one field because this information will be included in many letters and layouts.

Hello everyone, I recently started working with FM database and have been asked to implement a new feature to our current database. I made a portal with flight information, with different fields such as date, time, flight number, etc. For each record there may be many portal records, for example any person may go on many flights. (This is a student information database). The flight records are sorted by date. What I need to do is concatenate, all the flight information into a new field which represents flight summary. This is easily accomplished when I only have one flight, however when I have more than one, each flight must be sorted by date and put into the summary field. So what I need to be able to do is navigate through the portal while it remains sorted and concatenate this information onto a field. Can anyone help? Thanks in advance.