How to

[puker]

How can i add a validation routine to a database in order to not be able to add member information if the members primary key number does not exist?

Also is there any access function i can use for example reports. So i can let the user edit all information on all tables at any time. Instead of having individual forms for each one?

[NoellaG]

Hi,

First question:
---------------
as the conditions for a primary key are: the PK cannot be empty (Not Null) and the PK value has to be unique, it is impossible to enter a record when the PK field(s) contain no value.

Second question:
------------------
Reports are for printing data, not editing them. As for forms : as all tables have there own unique set of fields, it would be very inpractical and confusing to allow users filling in data in all tables at once. However, you can show related data in a form with a subform.

greetings
NG