Hi. How do I add a new table to a back end database file, and then get it to show up in my front end file as a linked table?

Many thanks - Mat.

Hi. How do I add a new table to a back end database file, and then get it to show up in my front end file as a linked table?

Many thanks - Mat.

1. Create the new table in the back end (adding data is optional)
2. Close the back end, and open the front end
3. On the FILE Menu, select "Get External Data" and then "Link Tables"
4. From the Pop-Up window, choose the folder containing the back end
5. Select and open the back end file
6. Highlight the table or tables from the list of available tables
7. Click OK

I think that will do it

Thanks very much - worked a treat.

Mat :D