Input Form - Populate dropdown box with Selections from diff Table

[Cheryl]

How do i populate a dropdown/list box with options from a different table
than the one being 'inputted' to. For example I want to choose create a
timesheet that saves/updates a Timesheet table and choose which Employee from
a dropdown list that is linked to an Employee Table. Then write the values to
the EmployeeID field on the Timesheet as it is being saved. Kind of how
lookup works when you add do it directly in Access. So that I use only the
values from the Employee table. This will then ensure that the proper ID will
be linked. I don't want to add the values myself to the option drop down
since it changes .. sometimes frequently.

We have frontpage 2003...

Can this be done using the database wizard? or should it be coded using ASP
the long way...

 

[rontev]

How do i populate a dropdown/list box with options from a different table
than the one being 'inputted' to. For example I want to choose create a
timesheet that saves/updates a Timesheet table and choose which Employee from
a dropdown list that is linked to an Employee Table. Then write the values to
the EmployeeID field on the Timesheet as it is being saved. Kind of how
lookup works when you add do it directly in Access. So that I use only the
values from the Employee table. This will then ensure that the proper ID will
be linked. I don't want to add the values myself to the option drop down
since it changes .. sometimes frequently.

We have frontpage 2003...

Can this be done using the database wizard? or should it be coded using ASP
the long way...

 

[rontev]

Within the boundaries of the form, install a new "database results" which
consists of the one field containing the drop-down list. You can specify
sort order, and criteria, like any other result posting, and specify "drop
down list" for the output format. Be sure the field has the name you want to
use for the target table for posting. Don't be shocked at the way the screen
looks in design mode - Front Page will add a lot of supervisory stuff which
will not be included in the actual output.

 

[Cheryl]

OK ty.. I will give it a try... It was just that I did try that logic
before... and it didn't like it.. but maybe I just did something wrong...
That was what I originally thought.. but it gave me a problem...

 

[Cheryl]

Does this also work when u use the Database Editor portion.. It gives me an
error.. but I may just be doing something else wrong...

 

[SAC]

I think you can use the database results wizard (insert/database/results)
and make sure you tell it you want a drop down menu.