Table link

[lsy]

Is it possible i create one master table and link few table together??
In the mdb that i attached there have 3 table - tblMaster, tblConfiguration1 and tblConfiguration2.
Using the relationship to link tblMaster's field Configuration to other 2 table Configuration field but there only showing 1 table data.
Is it allow in tblMaster able to show this 2 table together??

 

[Dennisk]

use a query to create a view from one or more tables.

 

[lsy]

use a query to create a view from one or more tables.

i don't get what you means by creating view??

 

[Dennisk]

a view is a query is a way of looking at tables. Do you know how to use the query designer as that is where you would link tables together to provide a view of the data.

 

[lsy]

a view is a query is a way of looking at tables. Do you know how to use the query designer as that is where you would link tables together to provide a view of the data.

Is it possible to link 2 table in 1?? i wish to link tblConfiguration1 and tblConfiguration2 into tblMaster table??which like i select Configuration1 in tblMaster table it will show the data in tblConfiguration1 and select Configuration2 in tblMaster table it will show the data in tblConfiguration2 data.
Do you have any link that can provide me the fundamental of RDBMS? i seem like bit dump in creating a database structure.
thanks.

 

[Dennisk]

if you want two or more tables to apprea as one then use a union query

here is an example

SELECT * FROM TblTABLE01
union all
SELECT * FROM TblTABLE02

so long as the number of columns are the save the above works fine otherwise you will have to specify a columns list but the number of columns output from each table must remain the same.