You *NOT* want to have one table per customer. Every time you have
a new customer you will need to create new queries, forms and reports
for the new customer. And what happens when you want to create
You are far better off having a customer table with a foreign key
being the customer ID in the child tables.
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at