2 related DBs (recruit and visit), related by a serial # which is unique in the recruit database. When editing an entry in the visit DB, I am getting error 504 when the form incorporates any related fields from the recruit DB. The only field that would require unique validation is the ID field in the recruit DB, but that's not being altered in any way. I need the option to edit on this form certain fields in the recruit DB, and it doesn't make sense why I am not allowed to. If I try to do it manually in FMP, I am allowed to edit the related fields. Any suggestions?

Bevin

Are you using a Portal? That seems to be the way to do it.

Good Luck.

Garry

Nope. Just editing a single record, one-to-one relationship.

I should use a portal for that?

Bevin

It may be worth a try, unless you use Inline Actions etc. A single line portal on a Layout would be all that is required.

However, without seeing some of your code it is a bit hard to guess. I'm not sure why it would be a Unique entry problem.

All the best.

Garry

Okay, now I'm confused a bit. You can display, but not edit, related record info on a page without using a portal? I guess I just never had a reason to do it before...only ever displayed it. If I change it to just replacement view tags vs input tags, it's all fine.

Bevin

Ok, here is the story. I tried it without a Portal. This is what you have to do; add a ".1" to the end of your field. e.g.:

<input type="text" name="myrelation::myfield.1" value="[FMP-Field:myrelation::myfield]">

Hope this helps.

Garry

Garry,

Thanks for the hints! It worked w/o the unique validation AND the ".1"

It works w/ the validation AND the portal AND the ".1"

Cool.

I like learning new tricks.

Bevin