Combo Box Problem

[Spiel.1984]

Hi There,

I am trying to create a combo box that would give different values for different records, i.e.

The Combo Box is called Related Projects, I would like the values of this to differ depending on which record I am in, so if I am in record # 1 it might be linked to records 3 & 7. Record 2 might be related to records 20 & 30 whilst record 4 might no be related to anything.

Does anyone have any idea how I can get this to work? I have created a table called Related Projects where I have successfully stored the related projects but I cannot figure out how to pull this information across from the table to display this correctly.

Any help would be greatly appreciated.

Cheers

Neil

 

[JamesMcS]

Well, if you've got a table showing what project is related to what, you could just base your combo box on that, but what would the box do afterward?

If you just want to display related projects I'd use a subform. Create a form based on your project-and-related-projects table, set it to continuous forms and use it as the record source of a subform on your main form. Link child and master fields, and presto - as you change records on the main form, the subform will show related projects.