Results 1 to 7 of 7

Thread: How to emulate data base in MS Excel?

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,446
    Location
    Forms are very rudimentary Ron, and as soon as you start getting complex I think they lose much of their usefulness.

    One thing (similalrly, just thinking out loud) you could try. Consider a Customer table, a Customer Sales and a Products table. You would use Forms to maintain the Customer and Product tables, simple id and details. For the Customer Sales, you would inject a DV of customer names, and a VLOOKUP to get the ID, and similarly for the Produccts. The Sales data would be a Form, or maybe just event driven input.

    Does that make some sense?
    is to have
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  2. #2
    VBAX Expert
    Joined
    Aug 2007
    Location
    Windermere, FL, a 'burb in the greater Orlando metro area.
    Posts
    567
    Location
    Quote Originally Posted by xld
    ... you would inject a DV of customer names ...
    Bob,

    It must be time for me to quit for today, I'm drawing a blank on decoding 'DV'.
    [DOH!] Never mind, that's Data > Validation. Still time to quit.

    Your suggestions make sense. I'll work with them over the weekend to see what I can pull together with minimal effort on my part.

    Have a wonderful weekend!

    Thanks,
    Ron
    Windermere, FL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •