Displaying Data

[Tyler08]

Morning all

My database records shifts worked by each individual on each site of each contract and the percentage of the shift booked.

I click the new record button, enter the date of the shift, select the Site from a combo box and the Contract name is displayed in a text box. Then I select the Operative’s name from a combo box. The Operative’s Grade is also selected from a combo box rather than displayed in a text box since it can change depending on which site he is booking to. For instance the Site 01 Site Supervisor might spend a day at Site 02 in which case he would book the day as a technician rather than a Site Supervisor.

Can I link the Operative to the Grade that he usually books to and display it as a default in a combo box as a function of the Operative Name selected but be able to change it to a different Grade if required?

I didn’t want to delete the relationships link between Shifts and Operative Grade to put a new one in between Operative Name and Operative Grade if it means loosing data.

Regards

Tyler

 

[twoplustwo]

I *think* you want cascading combo boxes from the description of it...

http://www.fontstuff.com/access/acctut10.htm

This is a really good starter.

 

[Tyler08]

Cheers twoplustwo

That’s close but not quite there! Using that example, if I select United Kingdom in the first combo then the second combo gets loaded with a list of UK Cities.

What I want is to be able to select UK in the first Combo, have a default city displayed in the second combo as a function of this choice but have the option to pick a different city if I want. (Edit Maybe that would work though! I'll go try it and get back)

Regards

Tyler