Front End / Back End 1

[mymou]

Hi All

After working with a db certain for ages - I have now had to start to make some substantial changes to the entire db - changing table structure and of course relationships.

The db is split (front-end and backend) - but I have a question regarding the relationships of these two dbs.

I had thought (up to now) that all relationships would be contained in the back end (silly idea as front ends can also contain tables). Now I think that both front and back end contain relationships.

This seems a little difficult and might cause problems if the relationships are different. How can I ensure that the relationship schema that I want to use is in the front and Backend - without having to manually create them from scratch? i.e. can you import relationships?

Thanks in advance.

Stew

 

[ToeShot]

You can import relationships the bad thing is they have to come with the tables. If you are making substantial enough changes you and are working with a front end back end db. You should reconsider the design. Alomost all tables should be located on the back end along with the relationships. more sound database design. Your front end should have jus form and queries and reports etc... I only know of a few front ends that actually need a table in the front end. and then theses tables are not related to any other table.

HTH

 

[mymou]

HiToeShot

Thanks for that.

So my original thoughts that all relationships would be contained in the back end isn't so silly.

So, as I have no tables in my front end - I can simply delete all relationships there - and know that it will use the relationships from the back end.

Clean.

Stew