Select field entry by pull down list of another table

[Dick Benton]

I would like to be able to select a field entry in Table A from a pull down list populated from Table B which is linked to Table A by that field. ie Table B contains the Server ID as key plus descriptive attributes. I also have an Applicatio9n Table and when entering data into the Application Table I wantto be able to enter the Server ID for that application and get it from a pull down list created from all the Server ID entries in the Server ID table

is this doable?
thanks
Dick

[mshmyob]

Yes.

cheers,

[mshmyob]

Just kidding.

If I understand you correctly you have two tables (tblServer, tblApplication) linked via the SERVERID. You have a form for filling in records for the tblApplication and wish to have a combo box that reads the values from tblServer that displays your ServerID descriptive name but then stores the ServerID into the Application table.

If that is correct then you need to:

1. Create a form that is BOUND to the Application table.
2. Create a combo box on the form with the following properties

• Control Source: ServerID (or whatever your field name is)
  Row Source: SELECT [tblServer].[ServerID], [tblServer].[ServerName] FROM tblServer ORDER BY [ServerName]; (change table names and field names as required)
  Bound Column = 1
  Column Count = 2
  Column Width = 0;1 (or whatever you want)

That should do it. If this is not what you wanted then please explain better.

cheers,

[Dick Benton]

many thanks