Related Field

[Turansky]

Hello,

I'm trying to post a record to a database where the field is defined to another database. From what I have read I think you would call it a related field. I know I'm suppose to put something else in the input tag but I don't understand it. Could someone give me a good example of what I need to do please.

<form name="event" method="post" action="http://xxx.xxx.xxx.xxx/FMPro">

<input type="hidden" name="-db" value="scoe_participant.fp5">

<input type="hidden" name="-lay" value="participant">

<input type="hidden" name="-format" value="scoe/confirm.html">

<input type="text" name="title">

<input type="submit" name="-new" value="Submit New Event">

</form>

SIDE NOTE: I don't know if this makes a difference or not but right now it's a 1 to 1 database and in the future this will become a 1 to many database.

Thank you

Kent

[Turansky]

I figured out what my problem was. When you define the related database there is a box that says to "Allow creation of related records" . . . . I did not have that checked.

And I'm not entirely sure if I want any of the other boxes checked either.

So now it works but it brings up a new question. It's creating a record in each database. But I'm not sure I want to do that?

My goal is to have this events database that administrators can go to add events to the database. Then the participant database is for when someone wants to sign up for the event they will then be related to that event.

Do I want all of my events to be added through the participant database so I get a duplicate record on each database? I might be looking at this all wrong but would love to hear comments from anyone and everyone please.

Thank you

Kent

[Garry Claridge]

Maybe have the "Participants" belonging to "Events". Use a portal in the "Events" database to access the related participants.

All the best.

Garry