D
dannerino
Access 2003 project (SQL Server 2K SP2 back end). Form based on sproc with
three joined tables. Need the many-est of the 3 to be the form's unique
table property (i.e. countries, cities and states tables, I need to update
data in the cities table only, so would need to include cities table in
unique table property for form).
The unique table property is a dropdown, but is not populated by any of my
three tables (or any at all). It won't accept me typing in the table's name
manually. I have tried with full referencing of table owner, etc. Until I
get that table included in Unique Table property, form is not updateable.
Resync command is there.
This is a common property that I set regularly. Won't work with this sproc.
Sproc is simple SELECT statement with a single WHERE clause referencing my
@theParam parameter. Once again, all steps I've done before, so I am doing
these parts correctly (syntax, etc.).
What am I missing? Why no populated Unique Table list?
three joined tables. Need the many-est of the 3 to be the form's unique
table property (i.e. countries, cities and states tables, I need to update
data in the cities table only, so would need to include cities table in
unique table property for form).
The unique table property is a dropdown, but is not populated by any of my
three tables (or any at all). It won't accept me typing in the table's name
manually. I have tried with full referencing of table owner, etc. Until I
get that table included in Unique Table property, form is not updateable.
Resync command is there.
This is a common property that I set regularly. Won't work with this sproc.
Sproc is simple SELECT statement with a single WHERE clause referencing my
@theParam parameter. Once again, all steps I've done before, so I am doing
these parts correctly (syntax, etc.).
What am I missing? Why no populated Unique Table list?