Tables Question

[kokopeli]

I am making an inventory program and I am confused. I have a database named Inventory.mdb. In that DB I have a table for the opening numbers, for the deliveries, sells,close and over/short. What I am doing right now is just using the open table. The inventory is done on a daily basis and I save the values in the txtClose boxes to the open table for the next record. My problem is I want to save all the numbers for each day in the appropriate tables. Right now I am not using a data control, I am doing it in code. Can I just copy the code I have for the open, but select from a different table, or should I use a bunch of data controls? I know this is a confusing question, but that is the best I can explain it.

[MartinLiss]

You're right your question is confusing, but if you have a program that already uses code to get data from a database, then by all means do not change it to use data controls.

One part of your question that is not clear is when you say "My problem is I want to save all the numbers for each day in the appropriate tables". Are you writing to a different table every day? In any case, please describe (examples would help) in detail what it is you are trying to do and I'm sure I or someone else can help.

[kokopeli]

I have 7 columns and 11 rows. The rows are for things like open, deliveries, book on hand, actual on hand. The columns are the different products. I have a different table for each row. That is part of the question too. Should it be one table with 77 fields or 11 tables with 7 fields like I have now. Right now I am wondering how to write to all 11 tables each day. I am working on it, and have two opening now, but it looks like it is going to be a mess. I am copying the SQL statement and changing the From statement, and of course I have to change other stuff too. Is there an easier way?

[kokopeli]

I have been messing with it, now I have no idea how to specify which table is being saved. If I do this in code it looks like I need one big table. Would seven data controls be better, one for each row.