[Cartoweb-users] Configuraztion of map file

[Giovanni Virdis]

Hi list,

 

I have two table in my postgis db:

 

Edifici and ppc_esposti

 

In the table Edifici there are the some record

The table ppc_esposti is empty

 

I want configure my application (maybe .map file) to work in this mode:

 

Show the layer whit the record of table edifice

When the user select the geometry after confirmation the system insert a
new record in ppc_esposti table with the reference of the selected row
of edifici table (ppc_esposti contain an filed that refernce to id of
edifice).

The system show the edit table with the value of ppc_esposti 

The user insert a value and save

The system insert into ppc_esposti the data insert from user

 

Example:

 

Edifici

 

ID_EDI GEOMETRY

 

1           xxxxxx

2          yyyyyyy

3          zzzzzzz

 

Ppc_Esposti

 

ID         ID_EDI    TIPOLOGIA

 

1          1          SCUOLA         

2          1          ALIMENTARI

3          2          CAMPO SPORTIVO

4          3          COMUNE

 

So the geometry is in the edifici table and in the ppc_esposti table
there are the reference of edifice and others data..

 

Can someone help me?

 

Thanks 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.maptools.org/pipermail/cartoweb-users/attachments/20080625/8395d881/attachment-0001.html