Problems with Data inputing into form

[Swillsy]

Hi Guys,

Bit of a problem here I am trying to add a method of viewing/adding/editing info on a form.
tables

tblstudent
studentid

tblrooms
roomid
roomNumber
Block

tblScheduleDetails
ScheduleID
Studentid
Roomid
Dates

Now my main form is based on a query of tblstudents & tblScheduleDetails,
I currently have a subform showing Room no, block, and schedule details.
I have a query which shows me the info fine, however I want to be able to input via this method.

How would I go about this?

thanks

James

 

[JohnLee]

Hi,

If I read your question right, what you need to do is create a many to many relationship between tblStudent and tblrooms tables, because a student can have access to many rooms and a room can have many students.

Once you've done that open up your main form in design view and select your subform, open up the properties and edit the Link Master and Link Child Fields properties so that the Primary key appears in both these properties. Then open your form up and you should be able to create your records as required.

I hope this is of assistance

John