How to display an error message

[Chuck]

I'm using A97. Table1 and table2 are related with a one to many relationship
of a text field. Table2 has the primary key which is indexed with no
duplicates. A data entry form for table1 gets the foreign key from a combo box
lookup of table2. Besides the primary key in table2, there are 2 other fields
that are used in reports. If the desired record is not in the lookup table, a
click on a command button opens a form to add a new record. If the primary key
for the new record is a duplicate for an existing primary key, the new record
is not saved. But there is nothing that warns that the primary key already
exists. How can I display a message box that shows a record for that primary
key already exists?

Just a wizard prodder
Chuck

[Rick Brandt]

Chuck wrote:

I'm using A97. Table1 and table2 are related with a one to many
relationship of a text field. Table2 has the primary key which is
indexed with no duplicates. A data entry form for table1 gets the
foreign key from a combo box lookup of table2. Besides the primary
key in table2, there are 2 other fields that are used in reports. If
the desired record is not in the lookup table, a click on a command
button opens a form to add a new record. If the primary key for the
new record is a duplicate for an existing primary key, the new record
is not saved. But there is nothing that warns that the primary key
already exists. How can I display a message box that shows a record
for that primary key already exists?

Just a wizard prodder
Chuck

Do you have warnings turned off in options? Attempting to insert a duplicate
primary key should give you an error.

--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Chuck]

On Thu, 26 May 2005 07:41:20 -0400, Chuck <li*****@schoollink.net> wrote:

I was making too much of a big deal of it.
Validation rule: <>[primary key field].

Just a wizard prodder
Chuck
--

I'm using A97. Table1 and table2 are related with a one to many relationship
of a text field. Table2 has the primary key which is indexed with no
duplicates. A data entry form for table1 gets the foreign key from a combo box
lookup of table2. Besides the primary key in table2, there are 2 other fields
that are used in reports. If the desired record is not in the lookup table, a
click on a command button opens a form to add a new record. If the primary key
for the new record is a duplicate for an existing primary key, the new record
is not saved. But there is nothing that warns that the primary key already
exists. How can I display a message box that shows a record for that primary
key already exists?

Just a wizard prodder
Chuck