A
aydin
I have two tables with a one-to-many relationship (let's
say Clients and Orders). I created a Clients form with an
Orders subform. I want to make sure that no client record
is accepted unless an order is entered for that client. I
wrote a macro that gives an error message if the client
name has been filled, but the order number is null. For
some reason, the error message appears immediately after I
enter the client information (before having the chance to
enter the order information in the subform).
Also, is there any way that we can define this requirement
in the table/data structure?
say Clients and Orders). I created a Clients form with an
Orders subform. I want to make sure that no client record
is accepted unless an order is entered for that client. I
wrote a macro that gives an error message if the client
name has been filled, but the order number is null. For
some reason, the error message appears immediately after I
enter the client information (before having the chance to
enter the order information in the subform).
Also, is there any way that we can define this requirement
in the table/data structure?