Problem and help needed with update form

[mayhem11]

I have a database with a form where end-users can go in and update only certain information in the database. Each record is distcint. I have many fields but will provide a few for an example:

qid progid prognm stid st measid meas lobid lob mbrst mbrsc q1update q2update q3update q4update
1 1 LIVE 1 CA 1 ACC 1 HMO 500 50 called sent email
2 1 LIVE 13 NY 1 ACC 1 HMO 500 25 called
3 1 LIVE 2 CO 1 ACC 1 HMO
4 1 LIVE 3 CT 1 ACC 1 HMO

My first issue is this form is to be an update form for fields that are blank that should be updated. So, I have a combobox to search by meas and there are thousands of other records but this is example. If the end-users see's in viewing ACC there are 4 entries and there are blanks, if they have the information they can enter it and update, I just don't know how to accomplish that. What event after they put the information in to do. The only fields that will ever be blank are mbrst, mbrsc, q1update, q2update, q3update, q4update.


My second issue is how to allow to update the q1update through q4update with notations when that time comes. I thought about a quarter table but then realized after going down that path that will not work because I have a primary key for each update. So, q1update would be 1, q2update would be 2, q3update would be 3 and q4update would be 4. So it would create a new record which I cannot have. Then I thought about putting in 4 textboxes where if it is a notation to be updated q1update fill in that text and so on. But that just looks really big on my update form.

So, how to I do an update event and second how would I go about the q1update through q4updates?

 

[dhookom]

Please use TGML tags so your data looks like data and we don't have to work to figure it out.
Is this what your actual data looks like? If so, how set are you on your table structure with repeating fields (qXupdate)? Do you understand your tables should be normalized?

[pre]
qid progid prognm stid st measid meas lobid lob mbrst mbrsc q1update q2update q3update q4update
1 1 LIVE 1 CA 1 ACC 1 HMO 500 50 called sent email
2 1 LIVE 13 NY 1 ACC 1 HMO 500 25 called
3 1 LIVE 2 CO 1 ACC 1 HMO
4 1 LIVE 3 CT 1 ACC 1 HMO
[/pre]


Duane
Hook'D on Access
MS Access MVP

 

[mayhem11]

The tables are normalized. The only fields they are allowed to update are:

mbrst, mbrsr, mbrsc, q1update, q2update, q3update, q4update.

I have multiple tables that link to a main one. The main table used to just be st_cd but I found that the entry form was not grabbing from the state table I created and other tables I created that linked to the main. So, I have for example a state table that has st_id for the primary key and then st_cd for the 2 letter code. The main table will have st_id and st_cd. So, I am not sure what you mean by normalized. I believe this is normalized???????