Multiple Auto Fill in Form

[mwebster]

Hello!

I am somewhat unfamiliar with Access... We have a database for the departmental webmasters at our company. In the database there are two tables:

Webmasters: contains information about the webmaster and the sites they work on
Departments: contains information about the departments including the number, name, division, and the path to the department's website on the server

A webmaster could be working on multiple sites. On the form for the particular webmaster I want the following columns:



DeptNo | Path

Where the path is automatically generated when you select the DeptNo in the combo box. The combo box is a list of the DeptNos in the Departments table and then saves it in the Webmasters table. I was able to get it to work on one but I want to be able to do this up to six times.

An example:
John Doe works on three department's websites: 111, 222, 333. Each website has their own path declared in the Departments table. In the form I want to select 111 for the Dept1, 222 for Dept2, and 333 for Dept3 with the Paths automatically being generated. I don't want the paths to be saved in the Webmaster's table, just want it to show on the form.

Any help is greatly appreciated!

[orange]

I think you want 2 combos, both unbound.
My Form is Form15.
Combo0: Webmasters
Row Source: SELECT distinct Webmasters.webmaster FROM Webmasters;

Combo2: Departments
Row Source: SELECT Webmasters.webmaster, Departments.DeptNo, Departments.pathToWebsite
FROM Departments INNER JOIN Webmasters ON Departments.DeptNo = Webmasters.deptNo
WHERE (((Webmasters.webmaster)=[Forms]![Form15]![Combo0].[value]));

These combos are display only-- nothing is saved to a Table.