Drop Down Lists

I'm want to be able to choose(including multiple selections) names from a drop down list that are fetched from the database(from table "Employees") and add them to table "Biotechnology".

Employees(ID,FirstName,LastName)
Biotechnology(ID,EmployeeID)

**assuming that EmployeeID in "Biotechnology" is the ID from "Employees" table

Example: We add Employees.ID(23, 33) to Biotechnology.EmployeeID

would be

Biotechnology:
[ID] [EmployeeID]
01 - 23
02 - 33Looks like an INSERT statement to me, possibly complicated by your user interface. What's the problem?

Drill Through Doesn't work.

I have a drill through that passes four parameters. Three are passed from the current selections in that reports parameters and the fourth needs to be the customer name they click on in the body of the report so it's passed as Fields!fieldname.Value. When I click on the customer name, the drillthough fires but the report simply doesn't load. If I remove the parameter from the field clicked on and just pass the three parameters, it goes to the drill through correctly and that fourth parameter just sets to the default for that parameter in that report.

I can then simply check that parameter and select the value from the list that is exactly the same as the value I was attempting to pass it in the drill through and report refreshes correctly.

Whatever it is, is something in the manner that the value is passed in the drill through specifically.

Any ideas?

Figured it out. The table with the link in it was alone in a detail area. I put it inside a list like the other reports involved in this function and then the link worked. Problem there was that there was no grouping in this data. It's a block of data for a particular week; only about 13 lines each with the same week_end_date. I simply added a grouping on the week (required by the list) and then everything worked fine.

Not sure why you can do a drill through in a list but when you do the same drillthrough in a table not in a list it didn't pass the clicked-on field value properly. Is this a bug?

Tim