Link multiple tables to one row


For some reason im getting stuck with my one function. I have a deals table - when creating a new deal, i have to link a contact person (table) and a property (table) to each new deal created.

The simplest way to do this would be the choice component - however, i fear the user experience might be tricky with presenting such large dataset in the choice component?

what other alternative do you think i have to allow the user to easily browse contacts and choose one and browse through properties and choose one? i have tried to create a list, and by clicking the list item writing the value to the designated deal column, but for some reason i dont have that option (not sure if my relations are setup wrong)

any advice appreciated

We do have search bars for lists that are large. Does that help your case? Or the user is not aware of what items would be included in the list?