I've created a contact databse. I just wonder how I can autofill the address, telephone, website of the same company? I see some solutions like use autofill-edit box-fill with existed value. But that still means I still need to input the first several number or letters. I want if I input certain company, the rest of the forms are autofilled automatically. And I can't use auto-enter by last visit because the data is out of sorted. Pls help. If there are two tables, I understand to use portal to build up a relationship. But how can I do in one table? This is my confusing.
Thanks in advance.