Create Child Table from Parent?

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

Hello,
Help me if you can. Now I believe there is a way this can be done. I
have a table Called Customer with all of the customer info. What I
need to happen is to have a macro create a sub-table with the customer
lastname as the table name to have all of their billing history. Is
there a way to do this?

Thanks in advance.
Steve
 
Steve,

I am sorry to say that this would not be a good database design. You
need to have a field in your Customer table which uniquely identifies
each customer, this wil be your Primary Key field. And then you need a
billing table where the billing details overall are entered, and this
table needs to have a field for the CustomerID of the customer that the
billing record relates to.

After this, it becomes easy to use a query to get the billing history of
any or each customer, and show this data on a form or report... but it
is not correct to have a separate table for each customer.
 
Back
Top