Re: Delivery Addresses

=?Utf-8?B?RGF2aWQgTSBD?= <DavidMC@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:96801071-AE1F-44B1-968A-7249B95D4389@xxxxxxxxxxxxx:

The way I see it, I have three options.

4) Display the actual address lines in the combo box. Allow the user to
filter the combo box so that it only displays addresses that are
applicable to the current customer.

3) Put the delivery address info in the main Order table, then have
another table for saved addresses and write a bit of code for
loading/saving those addresses to the main form (this would mean there
is some data duplication, but would allow new delivery addresses to be
entered hassle free).

With a bit of imagination and creative coding, it's possible to create a
fuzzy look up and try to identify the user's "21 St John Ave" with the
record in the database "21 Saint John's Avenue" but it's not always easy!

Hope that helps


Tim F

.

Relevant Pages

  • Re: inserting Adobe Illustrator graphics, more experience
    ... Word's "picture editing" tools, they can work only with bitmaps. ... The 'shapes' group are all very similar to CGM (Computer Graphics Metafile) ... as a group, it can have a name, a hyperlink, display ... the import filter, which says "Is this something like CGM?" ...
    (microsoft.public.mac.office.word)
  • Re: Drag from SP2 window to desktop?
    ... > display the same help text as originally displayed by the javascript ... Embedded within the HTML will be lines like this: ... > The idea is that if the user wants to perform a "filter" operation on one ... they can drag and drop the filter icon (which is surrounded ...
    (microsoft.public.windows.inetexplorer.ie6.browser)
  • Re: Search function
    ... effect the change in display. ... Dave Hargis, Microsoft Access MVP ... "Bill" wrote: ... simply set the filter and required. ...
    (microsoft.public.access.formscoding)
  • RE: Record Form
    ... I have found the filter and it is clear. ... NOT have the 'data entry' property set to yes, then it should display all the ... Look down at the navigation buttons and see how many ... form in design mode and, on the data tab of the properties window, check the ...
    (microsoft.public.access.gettingstarted)
  • Re: Code for Input Box
    ... front sheet and on pressing it I want it ... to filter the data on another worksheet (to have unique ... data on the other sheet to display records for that ... but also on selection of a value from the list. ...
    (microsoft.public.excel.programming)