Hi
I created a Search Form which displays records from a table. The records in that table are being entered through another form by the users and now has 180 records and growing.
This Search Form displays only a list of CandidateID, FullName & SupplierID (which is Foreign Key)
I have made this Search form un-editable, it is purely for search and then clicking the found record to go to a DetailsForm.
In this form however, I didn’t want a combo-box in the SupplierID to show the Supplier list and so I did the ‘Add from another table’ option and added Supplier as text box, it worked and the searches are all working.
But the list unfiltered, is only showing 44 records instead of the 180 records, as it is only listing the Primary Key’s records that have an entry in the SupplierID field. So then I removed it and tested it with just the SupplierID (FK) and still it is only showing 44 records.
What did I do wrong?
The Search form’s record source is
SELECT tblCandidates.*, tblSuppliers.Supplier
FROM tblSuppliers INNER JOIN tblCandidates ON tblSuppliers.SupplierID = tblCandidates.SupplierID;
Please help me fix it correctly so that it will show ALL Primary Key records even if the Supplier field is blank.
I created a Search Form which displays records from a table. The records in that table are being entered through another form by the users and now has 180 records and growing.
This Search Form displays only a list of CandidateID, FullName & SupplierID (which is Foreign Key)
I have made this Search form un-editable, it is purely for search and then clicking the found record to go to a DetailsForm.
In this form however, I didn’t want a combo-box in the SupplierID to show the Supplier list and so I did the ‘Add from another table’ option and added Supplier as text box, it worked and the searches are all working.
But the list unfiltered, is only showing 44 records instead of the 180 records, as it is only listing the Primary Key’s records that have an entry in the SupplierID field. So then I removed it and tested it with just the SupplierID (FK) and still it is only showing 44 records.
What did I do wrong?
The Search form’s record source is
SELECT tblCandidates.*, tblSuppliers.Supplier
FROM tblSuppliers INNER JOIN tblCandidates ON tblSuppliers.SupplierID = tblCandidates.SupplierID;
Please help me fix it correctly so that it will show ALL Primary Key records even if the Supplier field is blank.
