A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

adding records to linked tables



 
 
Thread Tools Display Modes
  #1  
Old April 25th, 2004, 07:57 AM
external usenet poster
 
Posts: n/a
Default 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  
Old April 25th, 2004, 12:19 PM
Marin Kostov
external usenet poster
 
Posts: n/a
Default 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  
Old April 26th, 2004, 07:20 PM
dandgard
external usenet poster
 
Posts: n/a
Default 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  
Old April 26th, 2004, 07:20 PM
dandgard
external usenet poster
 
Posts: n/a
Default 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  
Old April 26th, 2004, 07:27 PM
dandgard
external usenet poster
 
Posts: n/a
Default 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  
Old April 26th, 2004, 07:27 PM
dandgard
external usenet poster
 
Posts: n/a
Default 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  
Old April 27th, 2004, 03:24 AM
John Vinson
external usenet poster
 
Posts: n/a
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 09:55 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.