RE: Possible formsmart fields to look ahead?

Thanks Jerry,

As for more reading pleasure as you suggested, first i bought 2007 based on
the sales pitches @ M$'s web site that toots Access is so easy, that no one
neds to know about databses structure, design and so on. As always, it's
after the burden the wallet once had is releived by M$ that I again discover
a need for more follow-up, training and in-depth heacy duty reading. It's
finding the right book where the Author isn't showing of his/her techineese
and usies plain language. I'll look up Hernandez's book.


Thanks.


"Jerry Whittle" wrote:

If I am understanding your question correctly, you are putting in the
information for the Client in each sales record. If so, you are going about
it all wrong.

What you should have is a Client table with all the information about the
client such as name, phone numbers, email, etc. There should also be a field
that uniquely identifies the client like a Client_Number field.

Then in your Sales table you just enter the client number into a
Client_Number field in that table. When you need to see both the client
information and the related sales info, you join the two tables by the
Client_Number in a query.

If I am correct on what you are attempting, I highly recommend getting some
relational database training or reading "Database Design for Mere Mortals" by
Hernandez before proceeding any further on this database.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

"Shell" wrote:

Assume in my Sales Form that I have 5 Fields labeled Name, Address, City,
Country, and Zip - the other fields about quantoty and sales don't matter at
this point.

Assume I am entering data for a new client named John Brown and in the Name
field, I type John - let's pause here a sec for a sidebar.

Sidebar: Assume there is a John Doe, and a John Smith that already reside in
the dbase. I would continue entering the data in to the remaining 4 fields
for John Brown.

Let's assume now, that John Doe, whose data ia already in the dbase returns
and I need to enter nre data while keeping the old data for him. Is it
possible to have the form auto-complete the other four fields related to John
Doe - that is, I type "John Doe" and on Exit from there, by Tab or by click,
his Address, City Country and Zip information is looked up and are put into
their respective fields automatically?

S
.

Relevant Pages

  • RE: Possible formsmart fields to look ahead?
    ... information for the Client in each sales record. ... What you should have is a Client table with all the information about the ... Assume I am entering data for a new client named John Brown and in the Name ... Let's assume now, that John Doe, whose data ia already in the dbase returns ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Lookup latest entry 1
    ... Excel will automatically enclose the formula in braces, ... Miller, John, CA23, 52000, 1 ... John's sales figure would be ...
    (microsoft.public.excel)
  • Re: Please Help
    ... market and how you have weathered the storm to get where you are ... I happen to know who your client is and your ad is in fact ... Anyway, for our colleagues here, the position is indeed sales oriented ... to provide solid business solutions without a ton of "tech-speak". ...
    (comp.databases.pick)
  • Re: E-mailing & receiving data
    ... "John Nurick" wrote: ... > Do the sales people have Access installed on their computers? ... Let's call this database ... > 4) Where your code retrieves the edited data and updates the main ...
    (microsoft.public.access.externaldata)
  • Lookup latest entry 1
    ... I was wondering if I can get some Excel help for a problem I have ... Miller, John, CA23, 52000, 1 ... John's sales figure would be ...
    (microsoft.public.excel)
Loading