A
Andy
I have imported from Excel Three tables into Access 2007 (table 1,2 and 3)One
table refer to customer contact, the second too products purchased by that
customer, and the third other odd information about the customer. Last
invoice date, last time ordered, last time paid etc. There were many columns’
that had useless information which was not need and I have deleted these
columns. However, when I tried to delete some columns I was warned “If you
delete this column you will delete indexes†so I didn’t delete them but I’d
like to.
I want to bring all the customer info together in one form with sub forms
so I can check on say products order, then in another sub form on the
financial side see when a customer last ordered and when last paid, etc.
The tables (certainly two of them) are linked by RecID how do I sort all the
records so they end up with the correct customer as they should?
What is the best way to do this? I’m fairly new to Access 2007 easy steps
would help.
Sorry its a bit long.....
Many thanks.
Andy
table refer to customer contact, the second too products purchased by that
customer, and the third other odd information about the customer. Last
invoice date, last time ordered, last time paid etc. There were many columns’
that had useless information which was not need and I have deleted these
columns. However, when I tried to delete some columns I was warned “If you
delete this column you will delete indexes†so I didn’t delete them but I’d
like to.
I want to bring all the customer info together in one form with sub forms
so I can check on say products order, then in another sub form on the
financial side see when a customer last ordered and when last paid, etc.
The tables (certainly two of them) are linked by RecID how do I sort all the
records so they end up with the correct customer as they should?
What is the best way to do this? I’m fairly new to Access 2007 easy steps
would help.
Sorry its a bit long.....
Many thanks.
Andy