Lengthy Field Names

[shyamsundar]

Hi,

I have a database with 20 tables and number of fields ranging from 30 to 150. The field names are very lengthy, hence i have given numbers for the field names and tables for easy reference. (eg. 8.123 where 8 is table name and 123 is field name). And I have typed out the actual lengthy field names in caption column.

Now i want to provide a tool, for user defined queries and criteria.(i.e, user can select tables, fields and criteria by their own thru a combo box).

Now my problem is the field names are numbers and not names, How can i list the field names (caption) in the combo box.

Hope I am clear

Any help pleeeeeeeease.

Thanx in advance

Shyam
cwizshyam@yahoo.com

 

[smedvid]

First, I would reconsider using numeric references for table names and/or field names. I once had to take over a FoxPro system where that was the case. It was horrible to maintain, and I eventually rewrote the entire system. The developer did have a big cross reference table that stored all the table/field descriptions, however, the table was not properly maintained. With that said.

One option is the create an Object Definition (cross reference) table via Analyze-Documenter menu option. Save the results in a table. The Caption field reference is listed. htwh,



Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...