FIND CORRECT TABLE & ADD ENTRY

Hello-
I am creating a database to keep track of some of our raw materials. I
created a table for each bar size and type. I made a form that I want to
enter the records. I have a text box on the form that that will be equal to
the name of the correct table. I want record source to change depending on
that text box. That way it will add the record to the correct table.
Hopefully that makes sense...its late in the day for me. (and very
frustrated) Any help would be great, thanks.

Creating "... a table for each bar size and type..." is what you'd have to
do if you were using a spreadsheet. Setting up your Access relational
database this way will only cause both you and Access headaches.

Instead of having to figure out which table needs to be added to,
considering using ONE table, with fields needed to identify "bar size" and
"type".

Your design will require new tables every time there's a new bar size and/or
type. And new forms and new queries and new reports and ... - a maintenance
nightmare!

The well-normalized table approach will require ... a new row!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"ZigZagZak" wrote in message
...
Hello-
I am creating a database to keep track of some of our raw materials. I
created a table for each bar size and type. I made a form that I want to
enter the records. I have a text box on the form that that will be equal
to
the name of the correct table. I want record source to change depending
on
that text box. That way it will add the record to the correct table.
Hopefully that makes sense...its late in the day for me. (and very
frustrated) Any help would be great, thanks.

I created a table for each bar size and type.
That is a mistake. Use only one table and fields to store bar size and type.

Then your selection on the form can populate the field with the information.
--
KARL DEWEY
Build a little - Test a little


"ZigZagZak" wrote:

Hello-
I am creating a database to keep track of some of our raw materials. I
created a table for each bar size and type. I made a form that I want to
enter the records. I have a text box on the form that that will be equal to
the name of the correct table. I want record source to change depending on
that text box. That way it will add the record to the correct table.
Hopefully that makes sense...its late in the day for me. (and very
frustrated) Any help would be great, thanks.