If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
adding records to linked tables
Dear Friends,
I have seven tables(various details) linked to one table (name)I created a query and form. But couldn`t add records to linked tables. Thank You |
#2
|
|||
|
|||
adding records to linked tables
If you have created relationships, you need to force Referential Integrity.
Open the Relationships window, double-click the line between the tables, and check Enforce Referential Integrity. You may also check and Cascade Update and Cascade Delete. Press F1 and in the Answer Wizard type About relationships in an Access database. -- Marin Kostov Microsoft Office XP Master Instructor |
#3
|
|||
|
|||
adding records to linked tables
You must make sure that the query you created is updateable. Often when creating links between tables abiguities arise and access cannot tell what record in which table to update, at that point it just doesn't allow any updates or additions. If the query will allow updates then the form with the query as a data source should allow updates. If the query allows updates check the form to make sure the form allows additions. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#4
|
|||
|
|||
adding records to linked tables
You must make sure that the query you created is updateable. Often when creating links between tables abiguities arise and access cannot tell what record in which table to update, at that point it just doesn't allow any updates or additions. If the query will allow updates then the form with the query as a data source should allow updates. If the query allows updates check the form to make sure the form allows additions. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#5
|
|||
|
|||
adding records to linked tables
Also additions can be problematic, if you have a linked table in a one to many relationship and you must have an entry in the One to be able to create a record in the many - you may run into problems. You probably want to change your form to relate to the main table only and use subforms to tie the linked tables to it. In this fashion you can update the underlying tables in the subforms (access will allow you to link tables between form and subform) and be sure they meet the relationship requirements. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#6
|
|||
|
|||
adding records to linked tables
Also additions can be problematic, if you have a linked table in a one to many relationship and you must have an entry in the One to be able to create a record in the many - you may run into problems. You probably want to change your form to relate to the main table only and use subforms to tie the linked tables to it. In this fashion you can update the underlying tables in the subforms (access will allow you to link tables between form and subform) and be sure they meet the relationship requirements. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
#7
|
|||
|
|||
adding records to linked tables
On Sat, 24 Apr 2004 23:57:00 -0700,
wrote: Dear Friends, I have seven tables(various details) linked to one table (name)I created a query and form. But couldn`t add records to linked tables. Thank You Well? How are you trying to add them? Normally you would use seven Subforms, one for each linked table, on a Form based on the Name table. John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public |
Thread Tools | |
Display Modes | |
|
|