I am working with a database of private foundations for the Council on Philanthropy web site that consists of three different tables exported from a MS Access db.

The table that lists grants made to various charities is linked to the table with the main information about each foundation by sharing two fields - SORT_NAME and NAME

So, in order to add information about new grants made by a particular foundation to the grants table, I've attempted to add the new record using a URL generated with the html.pl file that relates to the foundations db. I can't get it to work. It looks like this:

http://www.kcphilnet.org/cgi-bin/db/fdn/db.cgi?db=grants&uid=*&add_form=1&SORT_NAME="Morelock_Charitable_Trust,_Alma"&NAME="Alma Morelock Charitable Trust"

This does call the correct form for adding, but does not have the form fields SORT_NAME and NAME prefilled with their values from the other db - i.e. "Morelock_Charitable_Trust,_Alma" and "Alma Morelock Charitable Trust" - prefilled as I had hoped.

Is this possible? What am I missing?




Michael Liimatta, Director of Education
Rescue College, Kansas City MO USA

Your column names would have to match to put the values in the other database file.

Although you should use $in{'ColumnName'} rather than the actual value in the Column/field.

Regards,

Eliot Lee
http://anthrotech.com/

Are you saying that both databases must have fields with exactly the same names?

That's how I've got things set up currently, but the URL still does not work.



Michael Liimatta, Director of Education
Rescue College, Kansas City MO USA

You might want to check out the FAQ noted below under the section "Linking / Sorting" for a thread called:

Entering Data Externally via links

You may also want to check out:

Making link in display for variable with spaces

I'm not positive this will help, but after reading the first thread it seems like it may provide information you could use.

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/