Tanks 2 both...

My db looks something like


Column1, Column2,
Invoice #, Customer Name, addy, phone, material cost, total
100 John Doe, 123 main, (916)xxx-xxxx, 600.00, 1200.00
101, etc etc etc

So these are different jobs and I don't want to map the material costs to the invoice cuz thats not part of my invoices unless its a Time and Material job. I don't do those too often so I could handle those seperately.

So I was hoping to just highlight a row, not a column obviously, and update my Excel downloaded invoice. Once Invoice #101 was created from the ss or db, I wouldn't want need that again. But the ss or db would be the master record for tax purposses at the end of the year.

Excel and Access are linked together and I'm sure I did something like that too, back in the day. I used SQL for data, mostly FoxPro, then Access a little bit.

CK the delimeters are an interesting thought. Certainly helps the mapping.

UX, the linking of each cell??? I'm thinking this through cuz in my example above I need the same column but for the next invoice I'd need the next row of data.

I really appreciate your help. It might be that I need to dig out Quickbooks. I'd rather use Access and Excel.