Possible formsmart fields to look ahead?

  • Thread starter Thread starter Shell
  • Start date Start date
S

Shell

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
 
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.
 
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.
 
Back
Top