Associated Fields

[Guest]

Hi,

I am trying to add to my existing form.
I would like to have a 'Description' field and a Comapny field in a list
format where the users chooses from list.
But is it possible to make it that when they choose a item in the
'description' field, the company name field automatically shows up?
and would both these fields still show up in reports and able to sort and
filter them?

 

[John Vinson]

Hi,

I am trying to add to my existing form.
I would like to have a 'Description' field and a Comapny field in a list
format where the users chooses from list.
But is it possible to make it that when they choose a item in the
'description' field, the company name field automatically shows up?
and would both these fields still show up in reports and able to sort and
filter them?

What's the structure of your underlying tables? You can certainly have
a Combo Box control (a dropdown list) on your Form, based on the
Company table.

The data IS IN THE TABLES. It'a not on the form; it's not on the
report. You can base your Report on a query containing the tables that
hold the data that you want reported, and sort by any field in any of
those tables, independently of the structure of any Form bound to
those tables.

John W. Vinson[MVP]