> So, is there a way to tell Filemaker to apply data from a relationship only once, and then leave it alone
yes, this is what lookup are there for.
So those fields must autoenter a value from a lookup, not a calculated value.
Aha! Excellent. I've never used lookups before, but now that I know what I'm after I'll start experimenting. Thanks so much for your quick response!
Do you enter each record, or does the person with the incident do it from their machine? You could have fields set to Auto-Enter Creation "Name" or "Account Name" and have others Auto-Enter a calculation using Get ( SystemPlatform ) and the Get ( SystemVersion) functions.
If you are entering all the records, then a lookup tied to that users profile sounds like the best option.
Indeed, myself and my supervisor would probably be the only maintainers of the database. I'd happened across that method you mention of auto-filling from username, and I'm definitely holding that in reserve if this becomes viable enough to deploy to everyone on staff.
I am new to FMP and want to do the same as the original poster. Could you explain more about using a lookup to do this? I want to choose a vendors name from a value list and have all the related fills automatically fill in, e.g. contact_name, contact_phone, contact_email, etc. I thought I might be able to adapt the script that was suggested in one of the replies, but I am new to scripts, so I am not sure how to proceed.