Search results

I tried that. Makes no difference at all, exactly the same result as with INNER JOIN :/

Hello all, Created a query based on one table, this table has few 1-many relationships. Query works as it should be until I replace FK numbers with texts from related table. It works for all table but one. When I add table T_area query starts to duplicate records, but only in the query, doesn't...

1. I know, but until now my main table was T_qa to record incidents, and If I remove relationship between user and this table how will it work? Remember that not all records from T_qa will have assigned task to T_task, so how will my location work (department, area, equipment)?? 2. Other...

Is this correct then? thanks

if I follow this, would I get where I supposed to be with my relationships? https://www.youtube.com/watch?v=SpMyGlEInGs But then my main table would store text i.e. Department, Area & equipment, instead of as currently numbers: 1,2,5, ...etc which I thought takes less space (for each record)

obviously, it's something I am not familiar with. Can you please step by step me?

I am still trying to understand your suggestion. The reason I have this "double" relationship is I need cascading combo hence relationship between T_department - T_Area - T_equipment) and also need to store values of this location in table T_qa (hence relationship T_qa-T_department & T_qa-T_area...

Shoji, this didn't work, after clicking on the button nothing has happened. Thanks I will just stick to my working version.

strWhereTaskCompleted = "tTaskCompleted = False" is looking for records without close date, (looking for nulls)

made it! another question: Is that even possible to have a "where statement" in DoCmd.openreport.... with values from combo and if combo is blank? or is above code the only way of dealing with combos with selected value and nulls?

I managed to get this working: But I don't know how to convert it into the DOCMD.... , I'm struggling with quotation marks.

Anyone please?

1. create query and add all tables? or only T_task and T_qa? 2. what do i do with it afterwards? 3. how serious this problem is (1-10) 4. if I dont do it, what would be next step in creating/editing new table for TASKs? thanks

sorry for digging out, what to do if nothing selected in either of the combos but still want to see whatever there is based only single combo? DoCmd.OpenReport "R_printTask", acPreview, , _ "tTaskCompleted = False And tUserFK = " & Me!cboMyActionsUser & " Or qaAreaFK = '" & Me!cboMyActionsArea...

ok then, but how?

Not really, as I mentioned in my previous post, user can enter a record into main table T_qa, without linking and creating record in table T_task. So how would user determine location (T_department, T_area)? Therefore the existing TASK table wont work, as table doesnt allow user to enter new...

This is how it works: User enters data into T_qa Each record in this table must have the following: -UserID (to track who reported it) -Location: T_department, T_area, T_equipment (to track where it happened) -all other tables on right hand side of the relationship image posted...

what if instead of creating another table, I would modify my current table T_Task, so user can add tasks without relating it to T_qa?

Guys, lets just drop it who's more right thing.. If I create separate table in the existing DB, can link it directly to T_area & T_equipment?

here is ful view if we have any quality problems, we report it to the T_QA table, then to prevent this happening in the future we create a TASKs, which are always related to 1 record in the QA table. Current layout been developed with help of Gina, on this forum. Therefore I strongly believe...