Hi All
I have a list of clients in a seperate table they have an auto number assigned which is the primary key and they are also assigned to differant practices. Three pieces of info in total.
In my main table the list of clients is used to populate a combobox/drop down menu. On the form for that table I would like it to automatically display the practice and the number when you select the client i.e. pull all the info through from the other table. Is this possible
Thanks in advance
I have a list of clients in a seperate table they have an auto number assigned which is the primary key and they are also assigned to differant practices. Three pieces of info in total.
In my main table the list of clients is used to populate a combobox/drop down menu. On the form for that table I would like it to automatically display the practice and the number when you select the client i.e. pull all the info through from the other table. Is this possible
Thanks in advance