I want to create a table that gets all of its contents from other tables within the same database.And that if i change something in the tables,this table will also be automatically updated.Can this be done?
2007-02-25 14:26:03 · 3 answers · asked by alfredo_pp 2 in Computers & Internet ➔ Programming & Design
Make a query which returns the data you want. After that, include it in the next query just as if it was a real table.
2007-02-25 14:30:56 · answer #1 · answered by Kokopelli 6 · 0⤊ 0⤋
Sure This can be done with a query or a linked table.
2007-02-25 17:02:44 · answer #2 · answered by mauricerogers 2 · 0⤊ 0⤋
i think what you mean is a custom View that binds two tables together with some primary key or seomthing and displays them as a single table. try searching google for MS Access tutorials
2007-02-25 14:31:35 · answer #3 · answered by Muhammed 3 · 0⤊ 0⤋