Replication ID's

[ajs112]

Hey guys,



How would one link a replication ID as a foreign key within a different table as they aren't numbers and not quite text?!

Thanks all!

Anthony

[June7]

What is a 'replication ID'?

What is the field type?

As long as the related fields are same data type - number to number or text to text or date to date (autonumber PK would be related to a number FK) - should work.

[ajs112]

It's a PK autonumber field with characters in it and doesnt seem to translate as a FK to other field types? e.g. {00000002-0000-0000-0000-000000000000} or {78952ED3-C741-4B91-96AF-A14697DEC4EA}

[June7]

AFAIK, Access autonumber field does not generate values with non-numeric characters. What is producing these values?

Is this a split db? What is the backend?

[ajs112]

Its an option in a table's design view for the autonumber PK data type in the "LookUp" tab at the bottom, used in lieu of Long Integer.

[June7]

I NEVER build lookups with alias in table. http://access.mvps.org/access/lookupfields.htm

The value you see is not the actual value in the field. You see the 'alias'.

I am not seeing any options on the Lookup tab for AutoNumber field.

[ajs112]

Ahhh, alrighty! Thanks for the information!

[ssanfu]

See the write up at http://www.trigeminal.com/usenet/usenet011.asp?1033

[June7]

Learned something new. Never even thought about this.