Hello,
I have the following problem:
2 tables that the input are from forms:
Table A with the following Fields : Transport Number And Pallet_ID (Generated Automatically). The user only have to place the transport number and form will generate a pallet ID (Form 1);
Table B: User have to confirm that those Pallet_ID were for the same transport number. So, the user have other form (Form 2) that will have to create a new registry with a transport number and the Pallet IDs that have in his area (different area from form 1);
I made a subform inside Form 2 for user knows the pallet IDs that were predicted for that transport number (Information from Form 1) and display the pallets IDs that he confirms that have in his area;
I have a query with connection between transport numbers from 2 tables and the atual behaviour is:
Example (Atual behaviour):
Transport number || Pallet ID predicted || Pallet ID confirmed
1234 001 001
1234 002 001
1234 003 001
1234 001 002
1234 002 002
1234 003 002
1234 001 003
1234 002 003
1234 003 003
But I want this behaviour:
Transport number || Pallet ID predicted || Pallet ID confirmed
1234 001 001
1234 002 002
1234 003 003
The objective is to know if there is any pallet missing. Any ideas? It is a problem of Union tables most probably but i cant figure out the solution.
Thank you!
I have the following problem:
2 tables that the input are from forms:
Table A with the following Fields : Transport Number And Pallet_ID (Generated Automatically). The user only have to place the transport number and form will generate a pallet ID (Form 1);
Table B: User have to confirm that those Pallet_ID were for the same transport number. So, the user have other form (Form 2) that will have to create a new registry with a transport number and the Pallet IDs that have in his area (different area from form 1);
I made a subform inside Form 2 for user knows the pallet IDs that were predicted for that transport number (Information from Form 1) and display the pallets IDs that he confirms that have in his area;
I have a query with connection between transport numbers from 2 tables and the atual behaviour is:
Example (Atual behaviour):
Transport number || Pallet ID predicted || Pallet ID confirmed
1234 001 001
1234 002 001
1234 003 001
1234 001 002
1234 002 002
1234 003 002
1234 001 003
1234 002 003
1234 003 003
But I want this behaviour:
Transport number || Pallet ID predicted || Pallet ID confirmed
1234 001 001
1234 002 002
1234 003 003
The objective is to know if there is any pallet missing. Any ideas? It is a problem of Union tables most probably but i cant figure out the solution.
Thank you!