Linking Of Tables

[kbsudhir]

Hi All,

I have two tables namely TrainingList & TrainingPlanner.

In TrainingPlanner when I have a column list called AvlTrainings which shows all the Trainings available in the traininglist table in a list box format which I just have select the training I need. But The in SchDate Column of TainingPlanner I am trying to provide all the available dates for this training from the traininglist table as selected in AvlTrainings field.

I have a schDate field in the traininglist table.

:think: :think:

Thanks
Sudhir

[CreganTur]

If this is for a Form, then you can create a ComboBox where the Row Source querries the table with your dates- just make sure that you include a WHERE clause that references the chosen value of your training course list box. You'll want to hardcode the SQL string in your form's module so you can reference the combobox.

[kbsudhir]

Thanks Randy,

Both of them are tables & I am not using form as of now.

I selected "Lookup" Tab in the field properties.
1. Selected Display Control as listbox
2. Row Source Type as "Table/Query"
3. Row Source is where I have give a query to this done.


Now can we implement it in the table instead of Form..???
Any ideas are welcome

Thanks
Sudhir