The Master table Primary key is varchar(10) but the detail table has a
varchar(50) as the joined field. I'll try changing it now.
Regards,
Ben
>From: Hiroshi Inoue <Inoue@tpf.co.jp>
>To: Ben Trewern <ben_trewern@hotmail.com>
>CC: pgsql-odbc@postgresql.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
_________________________________________________________________
Get Hotmail on your mobile phone http://www.msn.co.uk/msnmobile