Data Separation Model

[fmbug]

Please help me how can i do Data Separation Model. I want to create both Database and Interface in two different files.

[Vaughan]

The basic principle is this: create a table (or more) in one file. This will be the data file Create another file and delete the default table, so it is "empty" of data. This will be the interface file.

In the interface file, add a file reference to the data file. In the relationship graph of the interface file, add the table(s) in the data file. Create layouts in the interface fie based on the tables in the data file.

That's about it really.

Note that most relationships between the tables in the data file need to be created in BOTH the data and interface files.

[randhir]

There are two method for DSM

1)Inteface file and database file should be in server

2)interface file should be in client side and database file ion server

delete all the table from interface file import the table on database file in the interface file,add file reference to the database file.

[fmbug]

It was helpful.

Thanks u very much to both of you...

[fmbug]

Thanks you, what was this.