About Rob Henderson Expertise I can answer most MS Access design questions. I also welcome questions on database design and implementation and VBA programming questions.
I also have expierence in application design for all the Office components (Excel, Outlook, etc).
Question My programming knowledge is a little better then beginning.
Sorry did not phrase it right.
The tables are different.
I want to get 'customer number', 'shop name' and 'contact' from one table and then enter data in 2 other tables. Because there are so many fields to answer to (it's a survey) they would't all fit in 1 table.
I am using the first form to enter part of the data and then it goes to the next form to enter the rest of the data. I used and autolookup query on the first form to get the customer info and I can enter data to the end of the form. Then I used a macro to open the next form. I can enter data in the form but there seems to be no connection to the first form.
Thanks for you help
-------------------------
Followup To
Question -
how do i synchronize tables.
i am using two different sequential forms to inter data in matching tables
i do have a relationship between the two tables
??
also is it possible to use autolookup on more then 2 tables? Tried but cannot get it to work 3 table keeps it from adding new records
Thanks
Answer -
Hi
Can you give me some more information?
Why, if the tables are identical would you want to synchronise?
Lookups are used against one field (which implies one table) so the answer here would be no.
Can you give me some more information on this as well as I may be able to offer you an alternative.
rob
Answer Hi
Should the second form not be a subform in a one to one relationship? Then the data would have a relationship.
Saying that I'm not sure this is beneficial in your case.
In essence are you trying to...
Open a form
Complete some data
Open a second form
Have the second form open on a new record with pre filled fields from the first form?
