Database Editor & Linked Tables

[DAU73]

Is it possible to create a Database Editor (with or without using the wizard)
for multiple MS Access or PostgreSQL tables that are linked with primary and
foreign keys?

Thank you,

 

[Ian Haynes]

Is it possible to create a Database Editor (with or without using the

wizard)
for multiple MS Access or PostgreSQL tables that are linked with primary
and
foreign keys?

I don't use the Wizards but suspect it wouldn't be possible that way. It
would be possible with some hand coding, relatively easily. The data can be
'selected' using join query, you'd select an item based on it's primary key
and then use a function that updated all the tables in turn based on the
keys and amended data.

Take a look for some asp tutorials if you need examples of the basics.

 

[Stefan B Rusynko]

See http://www.asp101.com/samples/db_edit.asp
and for the join see
http://databases.aspfaq.com/database/how-do-i-present-one-to-many-relationships-in-my-asp-page.html

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________


| Is it possible to create a Database Editor (with or without using the wizard)
| for multiple MS Access or PostgreSQL tables that are linked with primary and
| foreign keys?
|
| Thank you,
| --
| DAU73