Hi,

I'm testing GeniusConnect and our information to sync to Outlook coming from more then one table. I created a view on the server to combine all the data.

On the table assigment screen I am able to see all the fields returned by the view but when finishing up I receive a message "The table must have at least one primary key".

Question #1: Can I use views to select a dataset as a data source at all? Certainly I can see them on the table selection list.

Question #2: If I can, how can I have a primary key in the view, or how can I pass the error message?

Thanks,

Steve

Steve Komaromi

---

Network Administrator, Systems Developer
Business Risk Partners, Inc.
Tel: 1-(860)-903-0039

Hello,

yes, you can use a View, but you must specifi a primary/unique field.
It must be a column or set of columns whose values uniquely identify a row in a table/View.

No two rows in a table can have the same primary key value.

Hello,

yes, you can use a View, but you must specifi a primary/unique field.
It must be a column or set of columns whose values uniquely identify a row in a table/View.

No two rows in a table can have the same primary key value.

Hi,

Could you give me an example how to make a view have primary field. I'm using SQL 2000 and see no option to set primary fields for views.

Thanks

Steve

Steve Komaromi

---

Network Administrator, Systems Developer
Business Risk Partners, Inc.
Tel: 1-(860)-903-0039

Hello,

you can't set primary key on a VIEW, you must define it in GeniusConnect config dialog.
(Assign Table Dialog->Mandatory keys):