Begrænsning på en 1 til M relation

Typisk ligger man den slags ind i applikationen ikke i databasen.

As arne says this would normally be in the application. So an easy way to do that would be to have a check on this in the forms BEFORE INSERT event.

If Dcount ("*", "FaturaTable", "fakturaID = ", Me.fakturaID ) = 10 Then

msgbox "Too many fakturalinier"

cancel = True

End if

Det var lige det jeg søgte, takker ;o)