Unique Table Property

[Lynn]

I have a form where the record source is a stored
procedure. The sp uses 5 tables although data is only
being changed in one table.

I can't set the unique table property because none of the
tables show in the list options.

All tables have primary keys and the stored proc is
returning the primary key of the table where records are
updated.

Does anyone know why this is happening?

 

[Lynn]

I figure out the fix.

My original stored proc had a variable for a parameter. I
removed the variable and refreshed my connection in the
adp. I was then able to choose my unique table.

I then added the variable back into the stored proc. The
adp kept the reference to my unique table although the
table did not show in the list.