Base: table data from another table

Is it possible to insert data in a table by selecting from another table’s data (i mean clicking in the table and having something like drop-down menu to choose data from the other table) ?

Not sure what you are getting at here? Data from multiple tables can easily be accessed in your form (via suitably configured sub-forms). It’s also possible in insert data from one table into another by executing an SQL INSERT statement. Which of these 2 possibilities are you trying to achieve? I don’t think you will necessarily need a ‘drop-down menu’ to do the job.