I need to create a new custom object called location.
Account, Contact and Location are all interconnected
A Location can only be created if it is LINKED to an Account
An Account can have multiple Location records associated to it
A Contact can only have ONE Location
I'm struggling to see how how the last two requirements would work
1 respuesta
Hi Glenn,
On your Location custom object create a custom field of type Lookup - it should lookup to Account object. Mark it as mandatory. This will allow Accounts to have multiple Locations and ensure that all Locations have an Account.
On Contact object create a custom field of type Lookup and have it lookup to Location. That way you can only select one Location for a Contact.
Thanks,
Mike.
