AHMEDRASHED
Member
- Local time
- Today, 04:04
- Joined
- Feb 2, 2020
- Messages
- 59
Hi
i try for long time To create a union query to make filter by (Customer name or Customer id )
Customer Name data : same source table ( tblcustomers )
want if i SEARCH BY Customer name To show recordes form (tblinvT& tblinvH ) ,
maybe error in relations to create it
1st screenshot query
2nd screenshot all relations
3rd screenshot the Form filter search by Customer
i try for long time To create a union query to make filter by (Customer name or Customer id )
Customer Name data : same source table ( tblcustomers )
want if i SEARCH BY Customer name To show recordes form (tblinvT& tblinvH ) ,
maybe error in relations to create it
1st screenshot query
2nd screenshot all relations
3rd screenshot the Form filter search by Customer