PC Review


Reply
Thread Tools Rate Thread

using 1 form to update 2 linked tables

 
 
New Member
Join Date: Jul 2005
Posts: 2
 
      6th Jul 2005
I am a big-time newbie to Access, so please accept my apologies if these questions are really dumb. I have 2 problems that are similar to each other, but I can't figure out how so solve them. So I hope someone can help me.

Problem 1: Using the same form to add entries into a field in a linked table

What I have: A field in one of my tables is linked to a list of values in another table. I've created a form where when I am entering data, I can use a combo-box to choose one of the values from the other table.

What I need: I need to add the ability to create a new entry into the list of values if it is not already on the list. For example, the main table contains information about a tutorial session with a field linked to a list of tutors (e.g., TUTORIALSESSION.TutorName links to TUTOR.TutorName). I would need to be able to add a new tutor to my list of tutors (TUTOR.TutorName) while entering data for each tutorial session if that tutor is not already listed in my tutor table.

Problem 2 expands upon Problem 1.

Problem 2: Using the same form to add entries into multiple fields in a linked table if a key value is new, or, if the key value already exists, getting the data from multiple fields related to that value and automatically entering them in 2 fields in the form.

What I have: As in Problem 1, a field in one of my tables is linked to a list of values in another table. I've created a form where when I am entering data, I can use a combo-box to choose one of the values from the other table.

What I need: (1) In my form, if a value is new (i.e., not already in the linked table and thus not in my drop-down combo-box), I need to add the ability to create a new entry into the list of values and add corresponding related information into the linked table. For example, the main table contains information about a tutorial session with a field linked to a list of students (e.g., TUTORIALSESSION.StudentID links to STUDENT.StudentID). I would need to be able to add a new StudentID, FirstName and LastName to my list of students in my STUDENT table while entering data for each tutorial session.

(2) If, however, the student is already in the student table, I would need to get the student's first and last name and have these automatically entered into associated fields in the form. At this point, the TUTORIALSESSION.StudentID link in the current record would need to be added, but not STUDENT.StudentID, STUDENT.FirstName or STUDENT.LastName as these last 3 already exist in the database.

I hope that was clear. Any help or suggestions would be greatly appreciated. Thanks!
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Insert,Update Data in sage (MS Access Linked tables) using Vb.net form Gurdeep Toor via AccessMonster.com Microsoft Access 2 12th Apr 2007 10:47 PM
Appending Records from Linked Tables to the *Real* Linked Tables tbl Microsoft Access Queries 2 22nd Jun 2006 01:42 AM
Re: using 1 form to update 2 linked tables Ronald Roberts Microsoft Access Forms 1 7th Jul 2005 06:58 PM
auto update linked fields in linked tables =?Utf-8?B?Smhvd2c4?= Microsoft Access Database Table Design 1 7th Nov 2003 07:08 PM
using linked table manager to update path on linked tables Nydia Microsoft Access 4 19th Aug 2003 11:33 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:30 PM.