I have just started working on Access for the first time. I have created the tables as per the guidelines on the Ms Help, I have also created a form. I now need to make sure that the tables are updated through the form that has been created. is there anyone who can assist with how to do this?
-
-
by my interpretation of your question, that is a very broad topic. please give us more information as to the specifics you are inquiring about. if you are brand new to access, a good way to learn would be to play around with the database templates that are installed with your version of access (u can also download them from microsoft.com).
regards,
nate
[Edit: Link deleted as essentially its a competing forum. Mary] -
As far as setting up the tables have a look at our tutorial on Database Normalization and Table Structures.
To update a table with a form you need to create a form bound to the table. When working with multiple tables things are a little more complicated. If you have tables with a one to one relationship (one record in table B for each record in table A) then you can create a query and bind the form to that instead of the table.
However, if there is a one to many relationship (one or more records in table B for each record in table A) then you need to use a subform to update table B.
As n8kindt said your question is a little too broad for any more definite information.
MaryComment
Comment