Hello, this is my first post!
I've got a three related databases. One has names. One has jobs. Many people do multiple jobs so there is also a relate DB that joins the information from the two. When the user enters a name in the relate DB, there is a lookup that fills in other data about the person. However, I'm constantly having to check whether a person is in the DB (and if not, add their name) beforehand or the required information would be looked up.
So, what I'd like to do is this: when I type a name in the "relate" DB, it will check the name DB. If the name is not present, it will add it and fill in the lookup information.
There is an option for "Allow creation of related records" when setting up the relationship. However, this only seems to work with portals.
Any suggestions? Is this even possible?
Thanks,
Jer
