Niklas

I used the technique above for a similar task. Now I would like to do it in a relationship (to show a portal). Is there any way of doing that? When I try it says something about the calc field not being indexable..

I have some nicely working relations between, let's say, products and orders. The orders are linked to one of the products, and shown in a portal (in the producst-file). What I would like to do is to be able to filter out a date-range in the orders, sum up the tolal order-value (of the found records) and print thes in a nice layout (in the products file). How do you do this? - Is it possible to do a search for a date-range in the order-file, then go to products and the portal reflects the search in the orders-file (so that only orders within the date-range are shown)? thanks!

"..let me just say that having customer names as primary keys is generally a bad idea. Try using a auto-entered serial number to base your relationships on.." - yes I know, but it's just a small number of customers so no harm, no? "Is this want you want? - no, got that part already. what I am working on is to be able to select customer and meter(s) and a time-period and get all the results (t

Ok, got it. The field of the parking-meter got it's values from another file. Changing that solved the problem. So now I have one popupmenu with customers, then all the meters that the selected customer have are displayed as checkboxes. Then I display all the invoices of the checked meters in a portal. That only leaves filtering out dates. I'd like two drop-downs with 1-12 and one for year that filters the invoices. Is that possible?

I suppose I don't have to do it in find-mode. Just setting up relationships should work fine. I have one file containing parking-meters. Another one that contains customers. Each customer can have one or several meters through a relation between the customer-name in both files. In the meters-file the parking-meter-name is unique. In the search I let the user select customer. In the next menu meters he selects between the meters that are connected to the selected customer. But when a different meter is selected, an error message is displayed, due to that the parking-meter-name is unique. That would indicate that I am modifying the file instead of just searching.. Hope this was a bit clearer..

Hall

Ok, got it.. thought the fields would show up by them selves.

Thanks for the quickt reply. I seem to be missing something.. How do you do this? Are there fields inside the portal?

Hello, I've set up a portal but no text is shown. It seems like the relation works, because I can select the number of rows that are supposed to be shown. And changes affect the number of lines that are selectable. So why doesn't any text show up?

I have gotten the idea behind (conditional) valuelists and they work fine. Now I want to display the result, not in a pulldown-menu or checkbox, just as regular text. I must be missing something obvious..?

I have gotten the idea behind (conditional) valuelists and they work fine. Now I want to display the result, not in a pulldown-menu or checkbox, but just as regular text. How?

Hello, I have one file that contains items, and another one that contains customers. The customers can have a lot of items. An item can only have one customer. So I've set it up so that you choose a customer in the items file, and in the customer file you can display all items that have the current customer. But when I change an item to belong to a different customer, this is not updated in the customer db. How do I update this? thanks!

Ok, got it. I interperated the allow changes to refer to changing of the content of the menu, not that you would be able to choose in the menu.. Where is the swedish help? It does not get installed. Any way to d-l the help (english, swedish, spanish)?

Hello, Pretty new to FM. I am building a sort of accounting system where I have one file with Customers and another one one that contains simple economic information. In this file I would like to have the customers shown as a dropdownlist where you choose a customer. So I create a field, define a new valuelist with the values of the field from the customers file. But when I run it, nothing appears in the menu.. thanks, /Niklas