help please!!

[bladedfeather]

how can i create a form from the table EMPLOYEES LEAVE that when i enter data on the form i will not enter numbers corresponding to the ID of the table for example department ID instead of i enter the number 2 which is the id of INTERNAL MEDICINE i will see a list of all the department. hope i explain it clearly.. thanks.. see attached file..

 

[Alansidman]

I think that what you are referring to is a combo box in your form.

Look at this:

http://www.youtube.com/watch?v=v_INowd8ro4

 

[bladedfeather]

I think that what you are referring to is a combo box in your form.



thank you Alansidman..this is what i want to do..

do you know the procedure how to show both the name and the surname in the form? thanks

 

[Alansidman]

If they are in two separate fields in your lookup table, then you will need to go into the properties for the combo box, and in the format tab, change the column widths to show the particular columns. Assume that you have three columns, ID, Last and First and you want to show Last and First, only. Change the widths to 0";1";1"

Alan