Re: Access 97 and pgsqlodbc version 7.03.0100

Yes there is a unique index on the master table's primary key, and there is
also an index on the detail table's foreign key.

Regards,

Ben

>From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
>To: Ben Trewern <ben_trewern(at)hotmail(dot)com>
>CC: pgsql-odbc(at)postgresql(dot)org
>Subject: Re: [ODBC] Access 97 and pgsqlodbc version 7.03.0100
>Date: Wed, 21 May 2003 10:58:26 +0900
>
>Ben Trewern wrote:
> >
> > This seems to have fixed the GPF problem but now if I look at a Master -
> > Detail form I get #Deleted in some of the fields in the detail subform:
> >
> > Field1 Field2 Descripton1 Field4 Field5
> >
>----------------------------------------------------------------------------------
> > 10 1/1/03 Description OK 1000.00 1.148
> > #Deleted #Deleted Description OK #Deleted #Deleted
> > #Deleted #Deleted Description OK #Deleted #Deleted
> >
> > I'm not sure if the above will look OK on your e-mail client but it is
>meant
> > to show the first line OK but the following lines have #Deleted
>everywhere
> > except the Description1 field which is a memo.
>
>Do you create an unique index on the table or specify a
>really unique identifier for the table ?
>
>regards,
>Hiroshi Inoue
> http://www.geocities.jp/inocchichichi/psqlodbc/
>
>---------------------------(end of broadcast)---------------------------
>TIP 5: Have you checked our extensive FAQ?
>
>http://www.postgresql.org/docs/faqs/FAQ.html

_________________________________________________________________
Find a cheaper internet access deal - choose one to suit you.
http://www.msn.co.uk/internetaccess