Hi List - I'm trying to write a query builder tool for users to build their own complex queries and save multiple queries. As part of this, I would like to provide the user with a list of all data fields on a form. (I.e. Excluding trim fields, table, column, display only fields). I've had a look around the database system and believe it should be possible to use a SQL menu to provide this.
Does anybody have a query that would provide what I'm looking for? I've looked at the Database table - FIELD and the other related FIELD_ tables, but can't find the marker that would tell you whether or not it's a data field. Any help appreciated! If it's not possible, then I can always use a Data Dictionary menu, but this also includes Display Only fields. Thanks, Gavin Coleman Senior Analyst/Programmer Computacenter (UK) Ltd Services & Solutions Hatfield Avenue Hatfield, Hertfordshire, AL10 9TW, United Kingdom T: +44 (0) 1707 631662 E: [EMAIL PROTECTED] W: www.computacenter.com ********************************************************************** COMPUTACENTER PLC is registered in England and Wales with the registered number 03110569. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW COMPUTACENTER (UK) Limited is registered in England and Wales with the registered number 01584718. Its registered office is at Hatfield Business Park, Hatfield Avenue, Hatfield, Hertfordshire AL10 9TW The contents of this email are intended for the named addressee only. It contains information which may be confidential and which may also be privileged. Unless you are the named addressee (or authorised to receive mail for the addressee) you may not copy or use it, or disclose it to anyone else. If you receive it in error please notify us immediately and then destroy it. Computacenter information is available from: http://www.computacenter.com ********************************************************************** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"