Overview
Sometimes when configuring connections to external databases, you might want to use the same source column for two or more properties in M-Files. You can do this by repeating the source column in your SELECT statement. This will return several instances of the source column, so you can map the different instances to different M-Files properties.
For example, you might need to map the source database's ID column to M-Files' Object ID column, and still want to import the source database's ID value to some property on the M-Files object's metadata. In this case you would add the ID column twice to your SELECT statement and then map one of the instances to Object ID and the other instance to the desired property on the object's metadata card.
Solution
The example above is illustrated in the following image:
NOTE: If you include several instances of a given source column to your external database connection, make sure not to include more than one instance of the property in the UPDATE and INSERT INTO statements if you allow writing from M-Files to the external database. If you use the ID column in a metadata property besides the Object ID, then make sure not to include the metadata property ("Customer ID" in the example above) in your UPDATE and INSERT INTO statements.
