A method and system for creating interrecord relationships between master data records stored in a relational database are provided. The method includes receiving information for a first master data record from a user, searching a plurality of master data records in the relational database for candidates that have a potential of being related to the processed master data record, the searching performed automatically in response to the receiving, determining at least one possible relationship type between the candidates found as a result of the searching and the first master data record, and presenting the at least one possible relationship type and the candidates found as a result of the searching to the user. The disclosed method and system allow a user to create and maintain relationships between multiple master data records with minimal steps.