Thanks for the reply, but just to clarify (sorry I'm a bit new to all this). With the view I've got, do I create a table that is exactly the same as the view, but with no data in it, and then use a rule on that table to bring the data from the view? Or am I over complicating this?
Many Thanks
Nick Haw
Hello,
If you create a table with suitable fields, including a primary key
and then use a select rule this will do it.
hth,
- Stuart
-----Original Message-----
From: Nick Haw [mailto:nick.haw@operagrp.com]
Sent: 12 June 2002 16:46
To: 'pgsql-interfaces@postgresql.org'
Subject: Views and Access 2000
OK, i have some views that I need people to be able to use in Access 2000. When I try an link them using my ODBC data source I always get a dialogue box which says "select unique record identifier" even though the table the view is using has got a primary key. I don't want this box to appear, is there anyway I can stop it?