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 » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Main/subform and data entry



 
 
Thread Tools Display Modes
  #1  
Old March 4th, 2009, 01:54 PM posted to microsoft.public.access.forms
Tim
external usenet poster
 
Posts: 780
Default Main/subform and data entry

I have a mainform that contains student info like stud name, age, and so on.
I'd like to create a new subform with the recordsource is the table DormInfo
that links to the mainform by DormID. A user will enter the student name and
then go down to input the dorm info.
My question is how can I make this subform to display data that are already
in the table AND also allow the user to input new data that are not there?
Thank you for your help in advance.
  #2  
Old March 4th, 2009, 05:40 PM posted to microsoft.public.access.forms
KARL DEWEY
external usenet poster
 
Posts: 10,767
Default Main/subform and data entry

You have it reversed. Form/subforms are for one-to-many relationships. One
student (your main form) will not have many dorm rooms (your subform).

Other the other hand a dorm can have many students.

Now again a form for student can use student table joined to dorm table to
indicate what room they occupy without using a subform.

--
KARL DEWEY
Build a little - Test a little


"Tim" wrote:

I have a mainform that contains student info like stud name, age, and so on.
I'd like to create a new subform with the recordsource is the table DormInfo
that links to the mainform by DormID. A user will enter the student name and
then go down to input the dorm info.
My question is how can I make this subform to display data that are already
in the table AND also allow the user to input new data that are not there?
Thank you for your help in advance.

 




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 03:15 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.