cant link forms using rowguid

[MCFeightfourfive]

Access 2000 front and SQL 2000 Back

When linking the child and parent fields in access 2000 I am using a
uniqueidentifier named rowguid from the SQL server backend. Apparently
access does not like the rowguid as a means of connecting a subform to a
form. Has anyone else run into this problem.

 

[Albert D. Kallal]

Hum, do you see any child records in the sub-form?

I would try adding a time stamp, and further exposing this time stamp (both
tables should have one exposed).

I would think as long as the link/child/master fields are set, this should
work....

 

[MCFeightfourfive]

I do not see any Child records, but I know they exist. When adding records
in the subform is enabled, the rowguid from the parent appears in the new
record. I'm not sure how the timestamp would help?

 

[MCFeightfourfive]

I just tried adding a record to the subform in question, after updating the
record dissappears from the subform, however, it definately exists in the
backend.