Help with auto fill in!

[Guest]

Hi all, I really need some help on a data base I am setting up. I have made a
customer data base where I fill in all the information about the customer.
When the customer comes in to the store I have made it so the customer ID is
the customers home phone number.

Now, here is when I get in to trubble.

When the customer buys something, I want to beable to print a receipt. I
would like it so when I put the customers ID number in on the receipt, it
will put in all the information for me such as his Name, address, city,.,
etc... How or what can I do to make the customer data base work with the
receipt data base? I also would like it to print the receipt for the customer.

 

[Guest]

FYI -- It's difficult to answer your question without more information;
however, based on your description, it sounds as if you have design issues.

1st, your receipt information and customer information should be in various
tables, not databases. These tables should be setup in a relational fashion.

2nd, I would find another method to use as the CustomerID since phone
numbers are not unique and they change often.

3rd, if your database structure is setup correctly, simply use a query to
display the customer information on the receipt.

 

[Guest]

Xroachx, you think you could take a look at what I have so far then and let
me know what you think? Anyone else who thinks they can help, let me know and
I will send you what I have so far. My e-mail address is: (e-mail address removed).