n:m in forms - best practices?

V

Volker Roth

Hi,

is there a recommended way to build up n:m relations in forms that
reside in adp projects? How do you deliver and fill and update the 3
created tables in one form?
Any idea, link, old tread or faq would help.

ciao
Volker
 
J

J. M. De Moor

Volker

We use a lot of VIEWs with INSTEAD OF triggers. Books by F Scott Barker are
a good start for some ideas on moving to forms in ADPs.

Joe
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recommended way to create n:m-relations in a form? 4
Displaying n:m relation without showing the in-between table. 3
ADP Security Best Practices 13
Reading and updating an Sql Server 2005 database from Access 2007 4
Sum with expression in form footer returns #error 3
Best way to set form's recordsource 7
Database Form security 3
MS Access - Form - Upload document to Sharepoint Server (whoes folder is mapped to my PC) from Acce 0

Top