Full Version: Auto updating fields
UtterAccess Forums > Microsoft® Access > Access Forms
Howdy, I think this is my trickiest question yet... I have attached a copy of a few objects from my db so you can see what I'm trying to achieve....the information within the fields is made up.
Ok, so from my Customer Profile Form, I want to click the "quote" button (which currently takes you the quote form). I would like a new quote to be created which includes specific information , such as [customer Name], [Address], [Agent] etc relating directly from the customer profile which automaticall comes across...Any suggestions??? I haven't attached all queries to the sample db as it probably would have been too large - so hopefully you can see what I mean from I have attached sad.gif ...If you could please give answers in the most simplest of descriptions...thanks sad.gif
Sorry - forgot attachment...
This is a "lo-fi" version of UA. To view the full version with more information, formatting and images, please click here.