What's wrong with my query?

[Grek]

Hi,
Do you have any idea what is wrong with my query?


Instead of having all my fields within the same table, I decided to create 4 tables (Internal tasks, Promoter Tasks, etc).
The issue is that now my query doesn’t return any result?
Is it due to the way the table are linked, or something like that?
Thanks,

[June7]

The UniqueID field in each table is an Autonumber. These ID's have no relationship. They might stay in sync if all tables are always populated together with new record. I see that your tables don't all have the same records. General and InternalTasks both have 4 records but the other two have less than four. So record 4 when it is created in IMTasks will not be related to the existing record 4 in General. Another risk with autonumber is that a new record can be initiated then aborted but the number will already have been committed. This can result in sequence gaps with autonumber.

The ID in General table needs to be Autonumber primary key and the ID fields in other tables need to be Number type foreign keys. Then join the 3 subordinate tables to General table. Change the Relationships to reflect this. You do have InternalTasks and IMTasks related to General but why is PromoterTasks related to InternalTasks? The jointypes of the Relationships and the query need to be 'Include all records from T_NewLaunches_General and only those records from...' Change jointypes with the current setup and you will get records but because of the Autonumber issue they will not be properly related.

[Grek]

Makes sense - thanks for your help, seems to be working now!