Hi, thanks for the quick reply. I had a look at the link and also this 'Lookup' fields from another table in a form - #3 by Villeroy.
This is very confusing on a first approach. The guides seem to be for Open Office and the stuff is not exactly the same nor in the same place, although similar. Also it would be great to have a simple tutorial to demonstrate the basic principles.
One thing I don’t understand yet is, does the ‘power filter’ need any sort of macro script?
From reading a bit I think the logic is to invert the ‘priority’ or relation between the main dataset and the list you pick the condition from.
So the list of conditions becomes the main form, while the bulk of the data to be displayed actually goes in a subform?
I still don’t understand how exactly to link the 2 data sets, so the selection in the first form goes to the :condition parameter in the other.
I want to show a list of names to pick from, but what goes into the SELECT :condition is an ID corresponding to that name. Can I just point to the table with this data, or do I need to make a Query with just ID and name first?
(why aren’t there any spaces between the paragraphs??? I wrote the first post the same way and the paragraphs have spaces between them)