Thread: PLEASE HELP ME URGENT about choosing only the ones that i want while entering the data to postgresql with pgaccess on linux or windows or pgadmin II
PLEASE HELP ME URGENT about choosing only the ones that i want while entering the data to postgresql with pgaccess on linux or windows or pgadmin II
From
Himmet Karaman
Date:
Can anyone help me about how can i configure it to be able to choose only some types of data (for example to enter the name of the city to one of the columns [or fields] the one who is entering th data must be able to choose only the cities that i want to be added and how can i make it possible to seem like a drop down menu in pgAdmin II or in pgAccess it while someone entering data to the postgresql) while entering new data to postgresql in pgadmin II or in pgaccess ..... Thank you ..... -- ::::::::::::::::::::::::::::::::::::::::::::::::: Research Assistant Himmet KARAMAN Istanbul Technical University Geodesy and Photogrammetry Eng. Department 34469 Maslak/ISTANBUL TURKEY Tel : +90 (212) 285 67 83 Fax : +90 (212) 285 34 20 Web : http://atlas.cc.itu.edu.tr/~karamanhi :::::::::::::::::::::::::::::::::::::::::::::::::
On Thu, 2003-04-10 at 06:06, Himmet Karaman wrote: > Can anyone help me about how can i configure it to be able to choose > only some types of data (for example to enter the name of the city to > one of the columns [or fields] the one who is entering th data must be > able to choose only the cities that i want to be added and how can i You want code tables. You can enforce the referential integrity via triggers or, if you like living on the edge, in the application. This isn't a difficult problem, but nor is it the type of thing you'll get resolved on mailing lists. You need a database developer, or you need to get some books and become one yourself. -- Tim Ellis Senior Database Architect and author, tedia2sql (http://tedia2sql.tigris.org) If this helped you, http://svcs.affero.net/rm.php?r=philovivero