Lookup box

[garywood84]

I have a form which is used to enter contact details into my database. This includes the organisation for which each contact works. We have quite a few contacts from each organisation.

To ensure that the organisation name is always entered exactly the same, I'd like to use a lookup box which allows the user to choose the organisation if it's already in the system, or to enter it if it's new and not already there.

Is it possible to have a lookup box which shows the values already entered in the field to which the input will be stored?

Gary

 

[Rickster57]

Combo box

Using a combo box will do just that.

 

[garywood84]

Rickster57,

Thanks for this. I can't believe I didn't realise myself that a combo box would do the trick. Yesterday was a long day...!

Cheers,

Gary