Form that updates table and adds info to another table?

[fsmith]

How does one make a form update the data in one table and add a line of data on another table?

 

[Khalid_Afridi]

for this you need normalization of data, study more about how to normalize data, relationship and data integrity.

 

[fsmith]

Thank you for heading me in a direction.

 

[fsmith]

Khalid

Thank you so much for pointing me in the right direction. I would have made a mess! I am restructuring my tables.

 

[Khalid_Afridi]

you are welcome fsmith,

just keep in mind some basic rules always
- avoid duplicate information i.e information should not be repeated while designing your tables
- every table should have primary key (even its not necessary, but good for relationship)
- keep primary and foreign key concept in mind during normalization.
- data integration is important, no orphan record should exist in related table.
- cascade update in related tables are important, cascade update, update the related key value in the primary table.
- normalize your tables upto 2NF (second normal form)
- good database design structure enhance data retrieval and processing in queries and forms.