Fields are required to be filled out even though not set as required (1 Viewer)

oliwia

New member
Local time
Today, 10:19
Joined
Oct 29, 2014
Messages
4
I have made a form based on related tables. it requires me to fill out every field, which I don't want. I didn't make them required. Why does it do that?
 

Minty

AWF VIP
Local time
Today, 18:19
Joined
Jul 26, 2013
Messages
10,371
You need to give us a lot more information. Can you give us the table structure and fields from the 'Related tables' and how you are putting them on the form.

Did you set an index on the fields - if so what type? Etc etc.
 

oliwia

New member
Local time
Today, 10:19
Joined
Oct 29, 2014
Messages
4
I have included the file with tables and the form. I didn't set any indexes. it seems like because all those values come from the same table, they are all related and therefore required.
There are 8 related tables that feed the main table. The form cannot be saved until all the fields are filled.
Maybe the tables should be set differently?
 

Attachments

  • non profit copy.accdb
    820 KB · Views: 71

JHB

Have been here a while
Local time
Today, 19:19
Joined
Jun 17, 2012
Messages
7,732
.. I didn't set any indexes...
Only for info:
There are a lot of indexes, open the table "Participant Information" in design view, click at the "Indexes" icon at the Ribbon/menu line.
But it wouldn't help you only to delete them, because you've related/linked all the tables you've to the "Participant Information" in different fields and that require you've to fill these fields.
If you don't want to fill these fields then delete the different relationships.
 

Users who are viewing this thread

Top Bottom