I was reading some of the other posts and saw that there is a way to post data from one table to another. If that's true how do you take data from one table(lookup) and place the data into fields of a form in another table. The reason being that we have a big parent table that has all customers with thier address and what ever connects them to us. Then when the customer has other activities such as is if he is a member or has bought tickets the customer is then put into the different activity tables. But i want the user who puts the data infoe into the form for the different activities to be able to use a lookup table of the parent table to find the customers and then pull the infoe into the form such as last name, first name, id number, etc. then i know they have the right information in the form because it is the only way the feild will fill is with the parent table infoe. Gosh! did i say that right! Is there any hope for me!
