Search results

Please, have a look into attached DB, I have added 2 tables tblArea and tblLocation, those are in direct relationship with tblDepartments. How to modify (table or relationship) to make it save data?

No, not in the footer, please ignore this section for now. In the Detail section, when entering a new record, how do I select an errands and equipment. I know I can add a cbo but where would this data be stored, if there is no relationship to T_qa?

Please see the attached. the field qaDeptFK, how do I store record data for dept, area, and equipment, id those three tables havent got a direct relationship to T_qa?

No, not really. I still am as confused. Basically the question is: Where doi store a new record data, in what field?

Thank you for the sample and explanation, I don't think this is the right example to clear my problem. I am struggling to explain myself. ok.... If you look into my database sample, the section I don't understand is those three tables, T_department, T_area and T_equipment. They have a one-many...

I can only add data from one table at a time, so it still doesn't work. I am sorry but i'm unable to follow your direction but still unable to create a combo that will work. Can you please attach an example DB? Please see the attached photo. This is the best I can get, but I don't want it to...

@RainLover. I created a query with all fields from tables: dept, area and equipment, the query does show data. When I change to row source from table to query, then open in form view, it just shows repeated records for each department, depending on how many different area and equipments is in...

1. Should there be a combo from qaDeptFK OR dDeptPK? 2. How can. I select a depf, an area and an equipment from one combo? I just don't get it. Doesn't add up in my head. Please exlpain a bit more.

right click worked, thanks :) previous post: yes I am happy with that. Another question, inT_qa there is qaDeptFK - added to form, works fine. but how to add correctly area and equipment. just create cbo? where data will be stored, if t_qa hasn't got those 2 fields?

Designed couple of forms. In the form based on T_qa, all fields that need to be combo are displayed as text box, how to transform them correctly into combo boxes? Do I need to change something in properties? or just delete them and add a new cbo with correct record source / control source ? thanks.

Thanks Gina, No worries. @Rainlover, You deleted relationship between tables TASK and USER, How I be able to assign a person to a task if there is no relationship. Please note a person selected in t_qa and t_task might/will be a different choice. At this stage I don't understand how can it...

Please check the attached file, converted to 2003 version. If relationships are correct, I will create forms and then ask for more help with filtering. Thank you

The DB is 2010, sorry it's the only one I have. Please use qa7 file uploaded by Gina, it's the latest one, I haven't made any changes since.

Ok thanks. 1. Are we leaving relationships as they are? I take it as everything is correct? 2. When to split DB? Now or after I finish everything?

Yes. That's correct. ( when entering data in a form)

I live in the UK, but work shifts. So every couple of days I'm awake while you guys are as well. I have no problem to fallow your steps to modify the relationships, but I still don't understand how can it work after we make the changes. The table user is called user not employees for the...

Ok then, so if I remove relationship between t_user and t_dept and also t_user and t_task. And in that place add one more table t_user1 and connect it to t_dept and t_task, it all will work better. Is that what you are trying to say?

If the change is only visual I can't see a point of doing it. Tables will work exactly the same. Won't cause any issues so what's the point? I just leave the relationships as they are as the change doesn't being anything. Your second message about relationship being wrong.... I don't...

@RainLover, Of what you said earlier, I understand that my t_user has too many relationships. I believe that they all needed due to two different list of users I need. I am not sure I my way of thinking is right, then correct me please and I perhaps should remove relationship between t_user...

I need to be able to select user in t_qa. Basically this is a name of person entering a record. I also need to be able to select user in t_task. This is to give a person task to do. The difference between them is that in t_qa I can only select people from specific dept but in t_task I can...