is there any way to input information in one table from another table. I know about the lookup field, but it only fills in one field for you. I would like them to be able to choose one field and then it fill in all the corresponding info with that field.


Thanks in advance