combo box in a Form-select one thing but input another

[Richardl78]

I have a many to many relationship, With many projects and many partners, each partner can work on many projects, each project can have many partners.

The problem I have is that I need to create a subform in the projects form to enter the partners.

I need to create a combo box that allow me to select a partner by name but actually records the partners ID in the link table with the corresponding project ID.

Can combo tables be used to do this?

I really want to do this without using vb.

Richard

 

[KenReay]

Hi

Richard, I have sent you an example of doing this, is there a problem with it?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK