AH!! problem with a relational database!!

[RossP]

Dear Forum Members:

I

[-Queue-]

Do you need to search on the Status field in MAIN or just display it? If you only need to display it, just put a field on the layout using the relationship to the ALUMNI file based on the unique id for each person or create a calculation in MAIN that displays this related field, if there will be records in MAIN which will not have a related ALUMNI record.

If you need to index this field for search capabilities, you'll need an Update script in the ALUMNI file that either sets the related MAIN record's status, using Set Field [relationship_MAIN::Status, Status] or calls a script in MAIN that goes to a layout containing your unique relationship id and performs a Relookup on that field.

If it's possible that ALUMNI may contain a record that is not currently in MAIN, test that [not IsEmpty(relationship_MAIN::id)] before updating MAIN's Status.

[RossP]

Hey, Poo-Bah:

Thanks for the advice and for responding to my post! My problem has been simplified... or at least I think I can now relate it in more simple language...

or maybe not, but either way, I figured out and implemented one solution... but now that solution is causing new problems (!!)

so I wrote a new post. "Keeping the data after removing the lookup... ???"

http://www.fmforums.com/threads/showflat...&PHPSESSID=

your council is more than welcome.

Thanks Again!