Hi,

I'm trying to do the following :

I have a Promtion_Code FORM based on a Promotion_Code table with primary key promotion_code - autonumber.

A CR_DEFECT FORM based on a CR_DEFECT table – primary key- ref_number -text

and a Promotion_items FORM which links both as 1 promotion code can have many CR_DEFECTS. The primary keys in this table are promotion_code and cr_defects



On my Promotion_code form i want the user to be able to enter all details relevant to a promotion.



1. I then want a button which will save all the details of the form and write it to the promotion code table.

2. store the auto number value that Access has assigned in the promtion_code primary key field,

3. open the form promotion_items and populate that stored number in the promotion_code field and then allow the user to select which cr_defects can go with that promotion.

The pop up form will be in datasheet view but I’m open to suggestions if there is a better way.

Been taking me a while to figure this out so any help is greatly appreciated.

Thanks

Parma