Query duplicates data

[Misiek]

Hi
Sorry for the delay.

Thank you for this, looks like it works. But I dont understand few things:
You removed few tables from query Q_task, so how is it possible for it to work in the form F_Tasktracker?
Also, in the F_Tasktracker, field Department name and area name have weird source, what does it actally mean and where is data from ?

Thank you

 

[HiTechCoach]

Hi
Sorry for the delay.

Thank you for this, looks like it works. But I dont understand few things:
You removed few tables from query Q_task, so how is it possible for it to work in the form F_Tasktracker?

Normally a form that is used to edit data has a single table in the query (I always use a query) for the record source.

Lookup tables are NOT included in the form's record source. You use other controls or methods to get the related data.

WHen creating a query for a report, then you might wanb to include all the lookup tables. Your Form's original query was designed for a report not a form

Also, in the F_Tasktracker, field Department name and area name have weird source, what does it actally mean and where is data from ?

You have to use some method to lookup the related data. The "weird source" is one possible way to lookup the related data. I use this method a lot. that

Based on your design it is not possible to include the look up tables in the form's record source without creating lots of duplicate records.

 

[Misiek]

hmm.... still dont really get it.
I noticed when I click on drop down for USER it shows 3 column, of USER AREA and something else.... so no it doesnt work.

I started again with my query and made direct relationship between table in that very query. This sorted my problem and all data shows as it should be.
I guess my problem is solved now.

Thank you all for input.

 

[HiTechCoach]

Thanks for the update.

Glad to hear you got it sorted out.