Hi Richard!

I am dealing with something very tricky for compliance purposes, and asking for your advise.

I have a Company Form and I created a Risk Assessment Form. Then I created a separate Main Menu for my Compliance Officer, so he view everything.

For my Risk Assessment Form, I used your Invoicing techhelp video as reference. Its the same as when you created a new Order for a client. In my case, I create a new company, then have to open the RA form to select same company name on combobox. (There is an RA Form button on my company form).

My problem is that I sometimes after I create a new company, I forget to update its corresponding RA Form.

So on the Compliance Officers main menu, there is a MainSubFormF. I made a subform, where on the left is the company name (from company form), and on right side is a combobox (from RA Form) where we can select the same company name.

Is there a way to force the user to only be able to choose the same company name from the combobox?