I have a form named 'NEWCALL' which has 4 fields called usrname(which is a combo box), room, telnumber and fullname on it.
I have a view called 'users' which contains 4 columns, usrname,room,telnumber and full name. (" Basically the information stored in the view is a list of computer users at an organisation")(*this view gets its values from a form called "add_new_user")
On the NEWCALL form i would like to be able to selct the usrname from a drop down list, which will then automatically fill in the room,telnumber and fullname fields for that user.
I have this formula in the usrname field on the NEWCALL form " @DbColumn("":"";"":"";"users";1) ". This looks at the first column in the users view and gives me a list of usrnames".
So what i would like to happen is for the rest of the fileds to be automatically filled in when i select one of the users.
Can this be done?, or am i way of the mark?
Hope that makes sense, I can send my database if it doesn't.
Any help or advice would be great as this is for my HNC project.