Help please

[bluenose76]

guys,

Thank you for your help thus far with this.

I am unsure of how the two db that you have posted are actually performing?

tbl_employee holds the names of those available to use.

how does tbl_assignment get populated?

attached is a screenshot of how I currently have the data sorted.

arran

 

[bluenose76]

i am also confronted with a debug error when trying to slick on the command within your form?

 

[rzw0wr]

Arran,
I need to know what error you are getting.
Tell us the error number or paste the line of code where the app stops.

I am not sure about your first question.

Dale

 

[ChrisO]

Using Dale’s data, the A2003 attachment may be one way of doing it.

Chris.