Please help: what is wrong with this query?

[drhassan]

I am trying to build a database by MS access 2010 for Animal Import Control Ports. I have three tables names are: Importers, Consignments, Staff, and one table named tbgroup (ID, importer ID, consignment ID, and Staff ID).

The problem is when I relate the primary key (the IDs) of each table with the tbgroup table, and run it in a query it dosen't retrieve any data from those tables.

What is wrong with this query.

Please any idea on how to build a good relationship for this database?



Database is attached for more digestion.

Thanks

[RayMilhon]

Your biggest problem is that the query uses inner joins from tbgroup to the other tables. There are 0 records in your tbgroup so 0 records are found. Try putting some sample data in that table or read up on Outer Joins.

[alansidman]

Cross Posting: http://www.access-programmers.co.uk/...d.php?t=226990

[drhassan]

I'm newly registered member if you noticed and I have no idea that the cross posting is unacceptable. My intention was only to find someone who can help me in this problem. Anyway I apologize for this inadvertent mistake and ignorance.

Thank you

[June7]

Here is what I understand about your data: it is documenting the shipment of animals - species, importer, and staff assigned.

Assuming importers and staff can have multiple consignments and each consignment will always have associated importer and one staff, consider tables:

Importers
ImpID (primary key)
ImpLastName
ImpFirstName
other fields for contact info

Staff
StaffID (primary key)
FirstName
LastName
other fields as needed

Consignments
ID (primary key)
ArrDate
Type
Gender
Qty
ImpID (foreign key)
StaffID (foreign key)