expecting ID to be added to table

[109bow]

Evening all,
I have a form training_edit_dates1 that allows me to add training types and dates for each operator, which is then saved in operator_training1.
When a training type and date is added for a operator I would of thought the field trainingtypeid in operator_training1 would show the id number relating to the training type, but it only shows a zero.
As beginner am I wrong to think a value should be shown?
Any advice most welcome. Thanks.

 

[CJ_London]

As beginner am I wrong to think a value should be shown?

As you have it set up, yes.

Your combo should have the controlsource as trainingtypeID and the rowsource should be

SELECT training_type.trainingtypeid, training_type.trainingtype
FROM training_type
ORDER BY training_type.trainingtype;

and in the combo columnwidths property, enter 0 to hide the first column

Also your operator_training1 table should not have the field trainingtype - it is not required because it is lookup up in the combo

 

[109bow]

Thanks, CJ_London, it makes a lot more sense