I have a 'client' field for a table project and I was going to use a select field to show all of the companies but as I understand it loading all of those records could be problamatic. Second choice was a popup dialog with a searchable list which would pass the id back to the form.

Is there a better way to do this or am I on the right track. Suggestions are very welcome.

Thanks, James