2011-11-03, 02:09 PM
So im sleepy because im having trouble sleeping for long periods of time and this is giving me troubles to think clearly so i need help on this, im have two tables (Histcxc and cxc), both tables are basically the same (They have the same fields) but histcxc contains bills that were already fully payed and cxc contains the bills that needs to be payed/havent been payed fully...
Both Tables share the same automatic Numeration in the field "numfac" (Ergo if the first 3 bills where fully payed and moved to histcxc they must still have the same numfac and the next bill added in cxc must be the number 4)...
Now the problem im having its that i dont know a way to make a query that shows the "numfac" of both tables combined:
![[Image: a-4.jpg]](http://i1107.photobucket.com/albums/h397/dante9898/a-4.jpg)
Sorry if i cant make much sense, this lack of sleep its annoying and i have to stay awake for at least 9 more hours :S
Both Tables share the same automatic Numeration in the field "numfac" (Ergo if the first 3 bills where fully payed and moved to histcxc they must still have the same numfac and the next bill added in cxc must be the number 4)...
Now the problem im having its that i dont know a way to make a query that shows the "numfac" of both tables combined:
![[Image: a-4.jpg]](http://i1107.photobucket.com/albums/h397/dante9898/a-4.jpg)
Sorry if i cant make much sense, this lack of sleep its annoying and i have to stay awake for at least 9 more hours :S

