Pull field from another relationship
In our database, there are many "contacts"...some contacts are "clients", while other are not. It is a one to one relationship, but I didn't want to combine the two forms as that would leave many empty fields. Instead, I created the CLIENT form that contains a lookup box that pulls the name from the CONTACT form.
We also have a form called CASES, where a case can have one or an infinite number of clients. I added a lookup box to that, but I cannot show the name field from the CONTACT form, I can only show the fields that are in the CLIENT form, leaving me with nothing useful for the user.
Any suggestions?
Thanks