Adding New Info to Table and Updating Form

[MTSPEER]

A week ago I created a database where I entered lots of data and created a form with it. Well there was empty fields when I created the form, and now that I have the data I have filled in the blanks. I was wondering how the tables and fields I updated will automatically update the form that I have created..



-Mark

[alansidman]

If the form you created is bound to the table, then it will happen automatically.

[MTSPEER]

How do I make it bound to the table? When I create the form under the wizard and select the tables does that automatically bound it? And I have the same fields in multiple tables, So will that automatically update each field in the tables?

[MTSPEER]

Sorry about that

[alansidman]

If you select a table and use the wizard to create a form, then that form is said to be bound to the that particular table. If you have other tables with the same name they would not be updated as you can only bind one form to one table. If you are looking to update data from one form to multiple tables, then I think you probably have a data normalization issue. Information should not be repeated in other tables. That is not in concert with the functionality of a RDBMS. Suggest you read the link below.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

[MTSPEER]

I fixed my database a little bit. But now Im just confused how to link my 3 tables together in a relationship. Does the primary key have to be the one to link the other table with? And does it have to link to the other primary key?

[alansidman]

No. You can join any table. It is common practice to have a primary key link to a foreign key. Did you read the link I suggested in the other thread on data base relationships?