Rabu, 25 Maret 2015

[MS_AccessPros] All data in two tables

 

Hi all, hope everybody good and in shape!
I've a sort of "concept" question today...

I've two table, eg. tbl_budget and tbl_turnover, A query is showing, starting for tbl_budget the actual turnover and the differences... linking two fields (code).
Now, I would like to see ALL data from both tables, in the same views (form based on the query) eg:

tbl_budget tbl_turnover

code code

1 1 --> ok

3 --> I can see all data from tbl_budget setting the relation link ok

5 -->?? how can I see also this code in the same query ???


Thanks, hope it is clear...I suppose it is easy for a access master, but I'm not! :-)


Ciao!

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)

.

__,_._,___

Tidak ada komentar:

Posting Komentar