FE/BE problem

[ghodges]

I have a little program which i have written.
It records the history of cheques that a buisness accepts

There are three tables

one is customers
a second for accounts
and a third for chque details

Each of the tables is link by a "one to many relationship"

When I view the first two tables I see a "+" sign at the first column of the table.
Once you click on the plus sign it will show related records

I have been using this feature for many years, however now I need to have multiusers accessing this database and hence I need to split the data base

as soon as I split the database , i loose this feature

I have explicitly reinstalled the relationships back after splitting but to no good

I have found that this is not just my little program but any program that becomes split


Has anybody else had this problem,
any idea greatfully accepted how to get arround it
Geoff

 

[Galaxiom]

The + sign on the records is the Subdatasheet. They are available on queries too. You will have to enable them on the linked table in the FE. Check out these properties of the table.
Subdatasheet Name, Child Link Fields, Master Link Fields.

They can be really handy for developers. However your users should not have direct access to either tables or queries so they are not really the way to go. Presentation should be done in Forms and Reports as the rights to the data and edit can be precisely controlled.

Use a subform to display the other information related to the current record. You can do so much more in a subform.

 

[ghodges]

Thanks very much for your reply,

Forms
Yes I do have the forms already in place, its just its so much quicker for me to use it this way, and i can manipulate data at ease.


Table Properties
I have done as you suggested, but not very successfully

I have gone to the front end and edited the properties of the table ( I receive the usual message that you will not be able to edit some properties)

The properties change nicely, and even autofill some places, so that makes you feel youve got it right.

Unfortunately it will not retain the properties of the table that you have selected. If you go back to look at the properties latter you see they have not changed at all

I have tried changing in both the front end and back end both with the same result........dismal failure

any other ideas?.....as i feel we are on the right track

 

[Galaxiom]

I checked out an old form where I had used a query with a Subdatasheet as the Source Object of the subform control.

The database is split and the subdatasheet still works fine.

I expect you would have to relink the tables after enabling in the back end but I can't explain why they don't stick in the back end.