Combo Boxes to update table

[KevinSlater]

Hi all, I have 2 tables, “DATA-CUSTOMER” and “DATA-MAIN”

“DATA-CUSTOMER” has the following fields:
Rep_code, Area_code, Name, Update (yes/no)

“DATA-MAIN” has the following fields:
Rep_code, Area_code, Name

I have a form which has 3 combo boxes, looking at the following fields: rep code, area code, name,. These combo boxes are picking the data up from querys which look at the table: “DATA-CUSTOMER”

I am trying to enable the user to select from the 3 combo boxes these 3 fields and it should update the table “DATA_MAIN” with these details. It appears to update the "DATA-MAIN" with one record but keeps overwritting the first record, and the combo fields in the form already have fields selected, i would like them to start of blank when entering the form.

Any help would be appreciated, attached is test database that I cant get to work properly.

cheers, Kevin

 

[Ally]

Hi Kevin

I think you may need a little more research into the basic concepts of tables and normalization before you go any further - You have no primary keys nor relationships.

If I've understood your aim correctly, your "main" table needs to reference the Customer table via an ID field, link these via the relationships window, then you will have a blank field on your form when you go to it.

HTH

Ally

 

[KevinSlater]

Hi Ally, thanks for your response i understand what you are saying but the attchement i posted was just a test database. i have relationships & primary keys on my real database, i have tried using relationships & keys on this test sample but still face the same problem, will have another go soon.

Kevin

 

[neileg]

Your form is opening on the existing record. If you change the form's Data Entry property to Yes, this will open on a new record every time.

 

[KevinSlater]

Thanks Neileg, im a complete numnut! , i should of spotted that simple mistake,
thats fixed it.

Cheers

Kevin