Skip to Content
Former Member
Sep 12, 2007 at 08:22 PM

Getting fields to display only what another field contains


Post Author: Travis

CA Forum: Data Connectivity and SQL

Hi all,

I'm sure the title is confusing, but I am trying to create a report that shows all the information about computers checked out to a certain area in our company.

To break it down...Areas is a field. (I havn't put it in the report yet)

Type is a fieldBrand is a fieldModel # is a fieldBar Code is a fieldSerial # is a fieldName is a fieldCheckout location is a field.

I want the above 7 fields to display that information for Area A of the Areas field. (The Areas field contains a huge list of areas and I want the 7 fields to display the information for just Area A)

I'm not sure what to do.

I hope this makes sense. If you have questions or I need to be more clear about something please let me know.

Thank you for taking the time to read and respond.