Adding New Tables & Forms in a Split database

Question

Dear All;

I just need your opinion on this issue below:

(A) I need to add three new tables in my application:

Procedure:

(1) I will create all of them in the Back end and use entity relationship within the back-end

(2) Create also the required forms within the back-end 

(3) Create new query required within the back-end

(4) Create a new report based on the new data query created with within the back-end

Finally close the BE and login the FE and import the following:

(1) New table links

(2) Forms linked to new tables

(3) New query

(4) New report

After that close the FE and open again the BE , this time now DELETE the new forms , query and report to ensure that they only remain in FE as part of FE. What I want to archive here is to ensure that the BE contain only tables nothing else and the FE contain :

(1) Macros

(2) Forms

(3) Queries

(4) Reports

(5) Modules

DO YOU SEE ANY PROBLEM HERE ? KINDLY ADVISE

Regards

Chris

Answer 1

Why are you creating anything except tables in the BE? After you create the tables, go to the FE and link the tables into the FE. Then create your forms, queries etc that use the new tables.

Answer 2

Hi,

Procedure:

(1) I will create all of them in the Back end and use entity relationship within the back-end

     OK.

     At this time close the BE. Open the FE, link new tables and create all other object.

Ciao Mimmo

Answer 3

Ok

Thanks I will do that

Regards

Chris