Create record in two tables

[icupat]

Hey, This is what I'd like to do.

When I create a record on one table, I want it to create a new record on the other table taking some of the values from the original table.

So i have tableA, with a related form. When I put in the "itemname" it creates a calculated value based on the name, it's recorded as "calcnum", there's other things recorded in the table aswell. I'd like for whenever I make a new record in the tableA for there to be a new record created in a tableB with ONLY the "itemname" and "calcnum" record, and none of the other records from tableA.

Thanks for your help,
Patrick

 

[TomCologne]

You may have a reason for your db structure, but should you be new to db building, some further research might be useful. Keywords: "Duplicate Data" and "Storing calculated values". I found this article about db design basics helpful:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q164172

If you search this forum, you will find more infos from more experienced members on "Calculated Values".

Just in case,

TomCologne