I have a form that has two primary combo boxes on it. The first selects the FIRM to use for the form. The second is used to select the PARTNER from that firm to use on the form. I would like the PARTNER combo to only list those PARTNERS that are assigned to that firm and not all the PARTNERS in the system.

The FIRM file has a 'FIRMID' that is unique. The PARTNER file also has a 'FIRMID' field that links it to the appropriate firm.

I assume that the ROWSOURCE for the PARTNER combo should be set for SQL and I should create an SQL statement that will work for this instance. I tried the following....

Select partner.partnername,partner.partnerid, firm.firmid from partner,firm where partner.firmid=firm.firmid into cursor cur1 order by 1

This produces an error about the OPERAND.

Am I on the right track here? Also, should I have the BOUND to column set? The PARTNER.PARTNERID needs to be stored in the file that the FORM is filling in so I have the control source set for LOG.PARTNERID.

Thanks