Search results

Maybe it's worth reviewing filtering. So we can setup fields type correctly?

I believe that 90% of entries, at least department would be selected. But if there will be an external quality issue, then this will be left blank.

think of it as a storage location, where department is a building, area is a rack, equipment is a shelf, User has to go through all of them to get to equipment. --------- what about the exception you mentioned earlier, why can't we just agree to disagree ?:) can my DB be designed with this...

just seen your version Gina, Looks good, but it won't work this way. 1. What if user wants to leave equipment blank, just get to area level. 2. I want each department to have specific areas and equipment, not visible on the list if another department was selected. So the cascade combos must...

i understand purpose of table, so we don't store the same data twice. I just have this feeling that you don't understand hat data I need to store for every record and here come the misunderstanding between us, and I can't get the relationship right. Please, forget my DB for a while and explain...

Please see the attached. Is that correct?

i know only tables can store data, thats why I am surprised there isn't a field in T_qa to store a value from T_equiment and T_area

when you create a table with customer addresses, and you want to select a country, then stare, then city. You have 4 tables, Tbl_Customer, Tbl_Country, Tbl_state, T_city. In my DB is very similar, where tbl_customers = T_qa tbl_country = T_dept tbl_state = T_area tbl_city = T_equipment those...

so instead of having relationship between T_qa and T_department, what do I need to relate? QA and Equipment?

yes. ps - each department has different equipments.

yes, but qa can be in relationship just to equipment, it needs to be with department, area and equipment.

ok, a user reports a Quality Accident (hence QA in the name), then the user needs to go through a drop down list to specify where this has happened, thats why There are three tables. User needs to select a department, then a specific area in this department, then a specific equipment in this area.

the same query but attached to department combo, or another query?

F_qa and then cboAreatbl and cboEquipmenttbl

please see the attached file from my previous post.

i have now, buy why it shows all records from the query? it has to be a combo to let user choose from the list, if I leave it as text box, user would have to enter a value, I don't want that, I want them to choose from the list.

ok, please see the attached. 2 unbound combo boxes, one for T_area and the other for T-equipment, When you enter a new record, how would those two save?

yes I understand it. Let say i want to enter a new record. i select department, the area, then equipment. I am able to select those on the screen, but when I close this form and reopen, it leaves those two blank. I my head, there should be 2 more fields in T_qa, qaAreaFK and qaEquipmentFK, so...

please see the attached, Ignore FOOTER section for now, I need to make the main form working first. Thanks

hi Gina, good to see you again :) No don't go, I need your input. Nothing has changed in the DB since you have uploaded file "qa7" on page 5. I have created a form to enter records to T_qa. However when I want to add a department and then area and equipment, those last two don't have a storage...