concatenating ID to use as primary key

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is this possible? I can do the concatenation but Access says the primary key
field is empty and therefore cannot save the record even though the
concatenation does appear in the field on the form. Help?
 
Are you sure that your field on your form is bound to the ID field?
Check the properties of the field and the Data Source of the field
should be the name of your ID field in the table.
 
Is this possible? I can do the concatenation but Access says the primary key
field is empty and therefore cannot save the record even though the
concatenation does appear in the field on the form. Help?
Click to expand...

Three comments:

- If the concatenation is being done in the Control Source property of
a form textbox, then it's just being calculated there and it will
*not* be stored in the table.

- Concatenating fields and storing them redundantly in another field
is a Very Bad Idea.

- A Primary Key can consist of up to *ten* fields - it needn't just be
one. Consider opening the table in design view, ctrl-clicking both or
all fields which jointly uniquely identify the record, and selecting
the Key icon.

John W. Vinson[MVP]
 
Thanks. I think you are suggesting a multiple field primary key and that may
be the best option.
 
Back
Top