Search results

... No, well I can only link the two in a form, having the field in a form and than create a query in a subform, in the query I relate to the formfield (maxnumber) and in the criteria I state that the number may not exceed the maxnumber. It is a workaround, cos when I want to refer directly to...

duplicate works but.. So the duplicate option in the query module helped get half the problem fixed. Thanks for the tip. I am still strugling with the other part, namely that one table only shows the 'ceiling' of the numbers that are allowed, and I have to match them with the actuall numbers...

Hi, I am working on a database for an airport. I made one table that registers all the numbers of sold airport tax numbers (these are tickets that are retrieved from the passengers, who purchase them earlier). I have another table that registers the next set of airport tax numbers that are...