Table has field as required but form allows new row without this field?

[not_rich_yet]

Hi all,

I have a feeling I've seen this answered before but I've searched and back-tracked to no avail!

I have a table with certain fields set as 'Required' which should mean a new row cannot be created without this data being entered....but when I use a form to enter this data a new row/record can be created without this data?

Any ideas?

Thanks,

nry

 

[Pat Hartman]

You must have a default set for it either in the form or in the table.

 

[not_rich_yet]

Hmm, the field I want to be filled in is part of an Appointment table. The specific field is Client: an appointment with no Client is kind of useless!

Anyhow, the table has a default value of 0 which it must have set up itself as I haven't done this bit. 0 is not an existing ClientID...it lets me create an appointment without selcting a Client, and then adds a new row to the Appointment table with 0 as the ClientID...

So, I set a Validation Rule in the table for this field so it cannot be 0! This has worked!

Ta,

nry

 

[Pat Hartman]

A better solution is to create a relationship between the appointments table and the client table using the relationship window. Then check the enforce referential integrity box. This will prevent orphan appointments.

 

[not_rich_yet]

I have no idea why I didn't have that relationship already setup anyhow!

Ta,

nry