Need help with a form.

[voidcranium]

In this thread I got some help on how to do a table(Multikey).
http://www.access-programmers.co.uk/forums/showthread.php?t=137668

Now I need some help on how to use this table on a form.

I need to be able to select several certificates and an expiration date for each employee.

John Doe
ID-301
Cert-1, expires 12/31/08
Cert-2, expires 10/31/07
and so on.

How do I make a form to do this?
I tried using the autoform in access but it does not work.

Thanks

 

[RuralGuy]

A 1:m relationship is usually displayed with a Form for the 1 side and a SubForm in Continuous Form mode for the many side.

 

[voidcranium]

A 1:m relationship is usually displayed with a Form for the 1 side and a SubForm in Continuous Form mode for the many side.

I am trying to get it to work.
I have never done anything like this so and I want to know how to do this.

I have a form and I put a sub form on it. But their is no information in the certification column. I would like that column to be a drop-down box so I can select it from the list.

Maybe I am doing something wrong?

 

[RuralGuy]

I would think the LinkChild/MasterFields would be the EmployeeID but I don't know your table structures or relationships.

 

[voidcranium]

I would think the LinkChild/MasterFields would be the EmployeeID but I don't know your table structures or relationships.

I'm not sure how to do this.
Here is my db could you look and see if I am on the right track?
The subform in on my form but I need the Certificate Name in a drop down list.
Now it just lets me put in the IDnumber.


Thanks for your help.

 

[pbaldy]

Also asked here:

http://www.access-programmers.co.uk/forums/showthread.php?t=137668