I am trying to use a database for a guestbook. The initial records into the database is from another database (Guestbook) and have a record_type of 'master'. I have used the modify_search function to enable a user to find the guestbook and then I use the add_record (changing the record_type "addrec". Works great.

Now my problem is creating the ability to find a guestbook (master) and view all of the comments (addrec). Any idea how I can accomplish this?

My brain must not be working too well today. I'm not sure what you want to do.


------------------
JPD

*heh heh heh*

I had a little trouble following it as well. Sorry imart, could you be a little clearer about what you mean?

Cheers,
adam

Ditto! I am also lost. It is not just JPDeni. Could you be more specific and possibly provide an example of what you are looking for??

------------------
Eliot Lee
Founder and Editor
Anthro TECH, L.L.C
http://www.anthrotech.com/
info@anthrotech.com
==========================
Coconino Community College
http://www.coco.cc.az.us/
Web Technology
Coordinator
elee@coco.cc.az.us

[This message has been edited by Eliot (edited May 27, 1999).]

Ok let me try again.

Within a database "guests", there are two record "categories" ... master (guestbook) and addrec(comments). The two records are related by a common field "m_id". (If I was in a relational database base world, I would create two tables, master and addrec and the primary key would be "m_id")

I would like a user to be able to create a search of master records only. Once the search is completed, the user could then select a particular record to view (the same way the sub modify routine works today).

Once the user has selected the record,I would like to search the database and return all of the associated "addrecs" that have the same m_id's.

I hope this is a little more clear.