Hi,
I have a table with two fields as shown below, is there a way that on my form when i choose "ClientA" from the combo box all the records associated with it can be displayed from "Field2". So when i choose "ClientA" i want a list with ProjectA and ProjectB
Example
Field1 Field2
ClientA ProjectA
ClientA ProjectB
ClientB ProjectC
ClientB ProjectD
Thanks a million for you help