Search the Community
Showing results for tags 'data type'.
I have two table that I'd like to relate. Each table has a column called person_ID that match up and normally could provide a parent-child relation. However, the one table the person_ID datatype is text (255), while in the other table the person_ID datatype is "ID". I can go into the design of the table and change the datatype to Autonumber which changes the datatype from text (255) to ID, and that allows me to relate the two tables. This seems problematic though, and so I wonder if there are other ways to go about this solving this challenge.