Data Entry

[tmcrouse]

I have 2 forms. The data entry form allows for new items to be entered into a main table only but the main table has relationships to other tables. I have comboboxes so the users can select from any item they wish and it is to populate to the main table, however I think it needs to only populate the primary key information if it is based on normalization. For example

main table items:

QID, stcd, progid, yr, mth, prodid, measureid, mbrt, mbrc, mbrr, effect

relation tables:

state: stcd
program: prodid, prognm, progdesc
yr: yr
mth: mth
product: prodid, prodnm
measure: measureid, measurenm, measuredesc, measuresub

So, I create my relationship and my query but when I select items to populate in each combobox I have for example, select prodnm from product and select stcd from state

So, they can see what they need to. If I bind to the items, it will update not only in my main table but change items in the relationship tables. So, I have to do unbound. But then unboud, when the edit button is selected, they are not able to see anything to be edited because the items are not bound.

Does this mean I cannot have a data entry and update form at same time? That I either have 1 form that is data entry and 1 form that is an update form????

 

[GinaWhipp]

I *think* your tables are incorrectly set up. However, before I can be sure please provide the real world business you are trying to provide a solution for. (I thought it was Inventory but then you lost me with the *Program* table.)

 

[tmcrouse]

My tables are normalized. I have for example state table with st_id and st_cd. In my main table, I have st_id. I changed my forms so that my comboboxes are unbound. Because if bound, they change the relationship table. The bound are my _id fields that are in the main table. I then hid these but needed them there to make sure that when say CA is selected from the combobox, the st_id shows up as 1. NY would be 13. CT is 2. So, my data entry form is fine. It does not go back and alter the relationship tables because I no longer have it set up as bound for like st_cd. St_cd is not in my main table, it is in the state table so when I bound it, that is why it was changing it. So, I think I am good to go. I have tested and it all seems to be working well with the exception of I don't want the data entry fields when they selected from the state drop down to clear on adding of record. Researching that fix.

 

[GinaWhipp]

Okay...

You can post a new question for your other issue should you not find an answer.