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.
You can post now and register later.
If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.
Question
telepet
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.
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.