yes. you can name your fields whatever you want.
it should be something like this:
ASSIGNMENTS ------ PERSONNEL
Sorry, can't quite understand that.
is that a field name or ?
I called it tasks because you said you had three tables - assignments, personnel, tasks.
Your field names can be called whatever you want.
There are two main conventions that most people follow (these could apply to field or table names):
or this one:
People normally try to stay away from spaces in names because if you want to convert your database or export it to other formats, not all databases likes spaces in their names or special characters.