Cannot set UniqueTable property

  • Thread starter Thread starter Marshall Smith
  • Start date Start date
M

Marshall Smith

I have a form based on a fairly simple stored procedure:

SELECT dbo.poPayable.PONumber AS TestPO, PMAssoc.AssocFull AS PMFull,
AccAssoc.AssocFull AS AccFull, dbo.poPayable.*
FROM dbo.admAssoc AccAssoc INNER JOIN
dbo.poPayable ON AccAssoc.AssocID =
dbo.poPayable.AccApp INNER JOIN
dbo.admAssoc PMAssoc ON dbo.poPayable.PMApp =
PMAssoc.AssocID
WHERE (dbo.poPayable.PONumber = @varPO)

The form returns all the correct records. But, I cannot set the UniqueTable
property, to allow the records to be edited. Both tables have primary keys
set, and both joins are on foreign keys. The only thing that makes this
different from other procedures is that I'm using one table twice.

In the form properties, any time I attempt to set the UniqueTable, there are
no choices in the drop-down box. And, it will not allow me to enter my own
text.

Any ideas?
 
Hi Marshall,
you can set this Prop. in the Form_Load-Event

me.uniqueTable = "dbo.MyTable"

Werner
 
That did the trick. Why I have to do that, I still don't understand. But,
it worked.
 
Back
Top