DataCollection TechHelp Video - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

DataCollection TechHelp Video

Jerry Fowler

5 years ago

I watched your techhelp video on data collection. My question is I also use you Helper Table and HelperType Table. How could I then update those using the same type of way you do in the video.
For example I have in the Helper Tables a reference for Miss and Mrs. So if I send out the email and some one updates it from Miss to Mrs. I can't just import it right?

	Adam Schwanz @Reply 5 years ago
You could make a query with a DLOOKUP that looks up what ID it should be changed to based on what string value they sent back, and then use the update on that field.

	Juan C Rivera @Reply 5 years ago
You know this is intresting I like to see this myself. Maybe since Richard is getting ready to release another ABCD hecan include this.

	Richard Rost @Reply 5 years ago
Adam's on the right track. You'll have to determine which fields are lookups from another table and process them accordingly.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen