Multi-field data entry

[Rolls]

Is there a way to prevent duplicate records from being entered into a table
where certain fields may contain nulls? For instance a name record:

Prefix
FName
MName
LName
Suffix

There can be no middle name, no suffix (Sr, Jr) and rarely only a first
name.

Multi-key indexing requires that all fields contain values.

 

[Guest]

you probably want to check out this:

Use DLookup() to get the value from the table.

Explanation and examples:
http://allenbrowne.com/casu-07.html


In there is an example very similar to yours:

Example 3:
In our third example, we need the full name from a Student table. But the
student table has the name split into FirstName and Surname fields, so we
need to refer to them both and add a space between. To show this information
on your form, add a textbox with ControlSource:
=DLookup("[FirstName] & ' ' & [Surname]", "Student", "StudentID = '" &
[StudentID] & "'")