Pull down menu

[VOLLEGAAS]

My problem is this: On a form in my db I've got a pull down menu that's shows which projects are being used. The problem is that 1 project can be up to 1000 records so the pull down menu shows the projectid 1000 times, when i change this so that it only shows it once i can't change the records. How can i solve this? What i want is that when you choose a project in the combo box you can still change records (maybe something in the after update state or something like that)

Thanks in advance

VOLLEGAAS

 

[VOLLEGAAS]

This seems to be a complicated problem because i've asked this question in a number of forums, no one knows the answer.
So if anyone has even the slightest idea of how this can be solved I would be vary gratefull.

 

[Rich]

Not sure I fully understand what you're trying to do, but why can you not display all the project info on a datasheet/cont form after selecting the single project from the combo?

 

[VOLLEGAAS]

The problem isn't that i can't display the project info the problem is that when i set the Unique Values to Yes it isn't possible to change records.
Any help would be appreciated