Changing data type in order to create a relationship

[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.

[nightowl]

Hi telepet,

The main requirements for establishing database table relationships in Caspio are as follows:

1. The data types for each field (parent and child) must be compatible. Please see the link: http://howto.caspio.com/tables-and-views/data-types/
2. One of the fields participating in the relationship, preferably the Person_ID on the parent side, must be a unique field (i.e. an AutoNumber or Prefixed AutoNumber field, or a field that has the Unique checkbox checked). Please read this How-To article: http://howto.caspio.com/tables-and-views/relationships/

As of now, I could not see any reason why changing to an AutoNumber (ID) date type is problematic for your use case. Please provide some examples of how the Person_ID field value should look like, e.g. a prefixed one like "PRS_10101" or something else. That way, we can see if workarounds are available.

[JayMont]

If you're creating relationship between tables using person_ID, its Data Type on the other tables should be Integer.