Thread: Data From Multiple Sources
05-16-10, 09:19 #1Registered User
- Join Date
- May 2010
Unanswered: Data From Multiple Sources
Can an Access 2007 form “send” data from it’s fields to a location other than its underlying table? If so how?
Here’s the scenario: I have an Address Table for customers. I have a form to enter that data directly.
But I’d also like to add addresses to the “Address table” —and make that “Address Table” data available-- to other forms in the database. Even if that “Address Table” is not the underlying table.
Picture a Messenger service. The clients of the service would likely have their main/billing address entered on some kind of Customer Info Form. Those clients however will have packages delivered to other “destination addresses.”
In fact, sometimes the origin might be the destination and the destination might be the origin. (Say when a law firm receives a package, signs the documents and then sends the documents back by the same messenger.)
Sometimes the customer will only be the one paying the bill, but the origin and destination of the package will be different from the Customer’s billing address.
And lastly, of course, the addresses aren’t unique to any one customer. Office buildings, court houses, apartment complexes will have the same address but be utilized by many different possible clients.
Thus, the need for a centralized location for addresses.
If there’s a template for a messenger or taxi service out there or something similar I’d be interested in perusing it.
05-16-10, 10:42 #2Moderator
Provided Answers: 19Hope this helps!
- Join Date
- Jun 2005
- Richmond, Virginia USA
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007