Related records

[igra]

I have 2 databases 1 for contacts and another for phone numbers of each contact, they are related by a "contactid" field, and displayed in one of the layouts in a portal.

How do i let users enter information to the phone numbers database from a web page using CDML in the same way they enter the information in the contacts layout including the contactid so that the relationship can be established.

any ideas...please help!!!

[softhead]

I'm not sure I understand what you mean. And why would you need two databases for that? Wouldn't one be enough to simply hold contacts and phone numbers?

Anita

[Hans Erik]

I have no complete solution, but I think you should consider this:

- Split your entry form into two, each pointing to a different database, and displayed in a different frame in the browser. The top frame is used for entering adress information and viewing the existing telephone numbers, the bottom frame is used for adding a new telephone number.

- To pass on the record ID for the telephone number, you could use the -token feature, or use a submit button on the addressframe that runs a script in the database (using the -script.prefind tag).

Might work?

Success

Hans Erik Hazelhorst

Database and Internet Consultant

email [email protected]