I want to create a lookup of a Relationship Table's ID in other field.
I don't want the lookup of the Record ID, but of the Table ID.
But in Define Database, I only have an ID field - an Auto enter Serial - for each record.
So, the lookup only copy that ID and I dont know how to lookup the Table IDs that are not the Record Id.
I attach a Print Screen of my layout.