Hi,
you can use Select dynamic to create content relations - in one of your content types/tables you need to add Select dynamic field with all possible items from other content type, so that user can choose related item. If you only have database tables you need to add column with values that relate this databse table to the other one, then you can join them in the query.