Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Form - multiple tables/queries Help!

I want to use a DB to manage Caravan Towing Courses.
Tables: tbl_CourseParticipants (ParticipantID, CourseID, ParticipantName, ParticipantDetails). tbl_Courses (CourseID,CourseBeginDate, CourseEndDate, CourseParticipantName). tbl_TowVehicle (VehID, VehMake, VehModel, VehGVM, VehGCM). tbl_Caravans (VanID, VanMake, VanModel, VanLength, VanAxles, VanATM).

I want to have a form with a list box populated using the CourseParticipantName and CourseID which then fills text boxes on the form (txt_CourseBeginDate), (txt_TowVehdetails), (txt_VanDetails) I could do this when I used Access using an after update event. How the heck can I achieve this using BASE??

Heres hoping there is a simple enough way for me to understand.

Mike

click to hide/show revision 2
None

Form - multiple tables/queries Help!

I want to use a DB to manage Caravan Towing Courses.
Courses.

Tables:

Tables:

tbl_CourseParticipants (ParticipantID, CourseID, ParticipantName, ParticipantDetails). 
ParticipantDetails)
tbl_Courses (CourseID,CourseBeginDate, CourseEndDate, CourseParticipantName). 
CourseParticipantName)
tbl_TowVehicle (VehID, VehMake, VehModel, VehGVM, VehGCM). 
VehGCM)
tbl_Caravans (VanID, VanMake, VanModel, VanLength, VanAxles, VanATM).

VanATM)

I want to have a form with a list box populated using the CourseParticipantName CourseParticipantName and CourseID CourseID which then fills text boxes on the form (txt_CourseBeginDate), (txt_TowVehdetails), (txt_VanDetails) (txt_VanDetails).

I could do this when I used Access using an after update after-update event. How the heck can I achieve this using BASE??

Heres Here's hoping there is a simple enough way for me to understand.

Mike