Database Editor & Linked Tables

D

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,
 
I

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?
Click to expand...

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.
 
S

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
 
Top