Required property for a foreign key

[Khalil Handal]

Hi,
Foreign keys in table design view should be Indexed: (duplicates OK).
My question is: Should they be "Required" ===> required property set to "Yes"?

Khalil

[Bob Fitz]

IMHO the answer is yes, so that data integrity is maintained.

[CJ_London]

Should they be "Required" ===> required property set to "Yes"?

if you have made the relationship 'maintain referential integrity' then required is academic, you won't be able to add a recorded without populating it. If you are not maintaining referential integrity, there will be a reason for that and usually it is because you want to be able to add a record without specifying a parent - so setting required=yes will force you to put a value in that is a) other than null and b) does not relate to an existing or potential future parent (such as a 0 or negative value)