Post DB SPLIT question.

[karassik]

I have split my database and it is working beautifully, but I come to the conclusion that I need another table. I added it in the front-end section (which is replicated). Somehow I don't think this is probably how I should do it, but I'm not in the mood for experimentation with our working DB. Can anyone tell me what the proper process is for later additions to the Tables(BE)? If I do add it to the BE, how do I create the new links?

This forum has been great, I don't know how I could have done this complicated a DB without it. Thanks to all who have contributed.

Nishan Karassik

 

[LarryDeLaruelle]

Nishan:

To solve your current problem, open the back end of the database, click on File/Get External Data/Import. Browse to the front end, select the new table and click on OK. This will bring a copy of the table into your backend.

Open the front end, delete the new table (or, to be safe, rename it) then click on File/Get External Data/Link. Browse to the back end, select the table and click on OK. This will create a link from the front end to the back end for that table.

For future use, simply create the new table in the back end then open the front end and link.

Good luck. Larry De Laruelle
ldelaruelle@familychildrenscenter.org

 

[karassik]

Great Thanks,

How do I deal with the replication of that table. That is I know that the table itself is just a link, but all the other tables have the replication logo next to them other than the newly linked table.

Nishan