Trying to have an auto link, not manual

1

I have a Contacts table. Has all the data for each unique contact. I then have contact history table. It lists all the contact point histories for each contact (every email, phone call with each contact). Each table has an AI PK called id. In the Contacts History table, I have a PeopleID field. It is manually entered and is the People’s PK id value.

I cannot have the same PK in both fields, because the histories field will have multiple records per PeopleID. How can I establish a link between the two? I want to do a lookup, beable to hover and see all the contacts from the PeopleID table. I cannot figure out how to do it?

2

Auto links are not supported currently- we are working on supporting type conversion for existing ID field (peopleID in this case) to a link field.

Meanwhile, you can use a hack to get around this limitation. See details here