duplicate autonumber & combo box error (1 Viewer)

[Manic_Rach]

hey guys, not sure if these have already been covered, could't find anything relevent when i searched.

First of all, I have a form that's for entering new jobs. The primary key is in the "Job Reference" field. I want the job reference to be automatically copied to another field on the same form once it is assigned. is this possible?

Secondly, I have a field for "material codes". it works fine as a text box but i want it as a combo box. when i make it as a combo box the list of material codes is empty. Any suggestions on how this can be fixed?

Thanks

Rachel

 

[Manic_Rach]

oooh! never mind about the combo box, i've fixed it, but still pondering about how to automatically copy the autonumber to another field

 

[sandy2011]

dont know first part...

this is how i reference combo boxes and they always work..

material codes -

create one field should be material codesID in main table/form (put as data type number)

create a seperate table material codes and put list entries into the table - ID will be primary key

Link both with a one to many relationship

MATERIAL CODES TBL MAIN TABLE
ID Material codes ID

tick all

Enforce referential Intergrity
cascade update and delete

when you have combo box on main table - it will display all the material codes from material codes table