help in supermarket query

[Nokia N93]

hello
i have a super market with customers who take goods from it ,
i want to enter his name , his address, tel No., and i want records to store the total amount to pay, date of purchase , amount to pay, amount remaining

the supermarket wants a querey to enter the name of the customer , and the whole records of purchases for the customer>
but we don't want a dropdown menu, because there are many customers

how can i do that ??

 

[jdraw]

Yes, you are looking at a traditional Customer, Order, OrderItems, Product, Payment,
type system.

Do you have a database now? If so, please post the tables and relationships as jpg.

see this for free data models that may be helpful
http://www.databaseanswers.org/data_models/customers_and_orders/index.htm
http://www.databaseanswers.org/data_models/customers_and_invoices/index.htm