Combining info from other combo's into 1 combo

[scoombs]

Hi All.

I have 3 combo box's:

Department 1
Department 2
Department 3

This is in a table/form called Staff. Also in this table is Staff Name and other relevent info.

I want a combo box that takes the values from Dept1,Dept2,Dept3 and puts them into one so when I do my payrole hours I can chose which department the time card is for. (NOTE 1 - Explained Bellow)

Now the twist.

I select thier name from a combo box (linked to staff table) no prob, this is simple databasing.

Next (NOTE 1) The drop down box bellow that is the department field. In this box is where the 3 Depts drop down.

How do I link all this together?

If someone can explain or create an example form that would be amazing! and pritty much complete my database.

 

[TheAceMan1]

How are ya scoombs . . . . .

If the [blue]departments[/blue] are fields, have a look at [purple]Union Queries![/purple]

If ya have any trouble, post back the [blue]PrimaryKey[/blue] of the table along with [blue]fieldnames[/blue] of interest and their data types (autonumber, text, numeric, date, ect).

See Ya! . . . . . .

 

[scoombs]

Hi,

I emailed you the database so you can see for yourself cause its a hard one to explain.

I want in the form Time Sheet's, A drop down name box (source from Staff Form), once you have selected the name a drop down list for departments (source from the 3 selected drop down options in Staff form)

Then staff code to popup automaticly. according to name, source from Staff / Staff Code.

It seemed easier to send it accross cause I have been working on it for about 10 hours and have reached breaking point!

The DB needs a bit of cleaning up. Appologies for the messy ness.

Thanks for all your help.

Steve