Hi Mary,
I've taken a look and the fields in the query are not actually the ones that are joined by relationships.
I have below the tables involved and the data types and formats as requested.
COURSES
CourseID Number PRIMARY KEY
CourseName Text
Duration Number
Cost Currency
MaxNo Number
MinNo...
NikkiR
Last Activity: Dec 1 '06, 08:48 PM
Joined: Nov 23 '06
Location:
-
No, still coming up with the value parameters...Leave a comment:
-
This is now asking for Value Parameters on the attendees and contacts....Leave a comment:
-
As requested:
SELECT Courses.CourseN ame, Courses.Duratio n, Courses.Cost, Courses.MaxNo, Courses.MinNo, Events.Date, Events.StartTim e, Events.EndTime, Tutors.TutorNam e, Venues.VenueNam e, Attendees.Foren ame, Attendees.Surna me, Contacts.[Company Name]
FROM (Venues INNER JOIN (Tutors INNER JOIN (Courses INNER JOIN Events ON Courses.CourseI D = Events.CourseID ) ON Tutors.TutorID = Events.TutorID) ON Venues.VenueID = Events.VenueID)...Leave a comment:
-
Right,
I have tried that and I can only get half way along the record and then it stops me entering the information.
NikkiLeave a comment:
-
The subforms are based on a query. I tried to update the form and the first part of the query could be updated but then when I got to what would be the first subform again it would not let me update.
Does that help with identifying the problem?...Leave a comment:
-
I Can't Update Info in my subforms
Hi, I'm new to the forum and I am currently designing a database that my colleagues can use to book people onto our courses.
I have a form set up with two subforms. The main form is one that has the course details, I then have a subform with the individual dates throughout the year. I also have a further subform that shows who has booked onto each date when I am on the course and date applicable.
Unfortunately I do...
No activity results to display
Leave a comment: