Lets say that we have 2 tables in Postgis:
Table 1 (PIPE): -ID -pipe_type_id -geometry Table 2 (PIPE_TYPE): -ID -type
PIPE.pipe_type_id - PIPE_TYPE.ID
Table PIPE is empty. Table PIPE_TYPE is filled with values.
I need to draw a line in QGIS directly to PIPE.geometry column. After the line is drawn I need a popup window to appear with an option to choose PIPE_TYPE.type value for that line. After submitting, correct value of PIPE_TYPE.ID should be stored in PIPE.pipe_type_id column.
I did this with Bentley Map using their Map Administrator and Oracle DB, but I want to try this with QGIS + Postgis. Is it possible?