Create references on new Object

Markfre1

I'm creating a new object (USER) using the 'Create' from and existing object (CUSTOMER). I update all the (USER) attributes, but the reference file does not get created.

For example, a Company has a main User. When I create the company, I create the User behind the scenes with a create statement and update all the fields. But the reference file doesn't get created so if I display the user, the company doesn't display or display the company and the user doesn't show.

But if I click Add, then all the users pop up, I select it, and its gets attached to the customer (reference file gets updated). Is there a way when using the create, or another option when creating the company, to have the references file created.

Thanks for any help as I'm stuck on this one.

Mark

customaware

Please show the two BOs and their attribute Mark.

What type of reference between each? Peer, Owned By or Owned.

I suspect the way you are doing it, you will need to assign the reference BO as part of the CREATE.

Markfre1

Hi Mark,

This is part of a tenant login system I am setting up. It's kind of unique. Whenever a Company, Accountant, Staff member, etc. gets created, I add this user to a Master Login user file if it does not exist in the Master user file

Therefore I end up with one user login, one password across all tenants, but that Master user can have access (where permitted) to any tenant, company, etc..

So my understanding is this should be a peer relationship, and multiple, multiple. Because a Master User can reference for example multiple companies, and companies can have multiple tenants users.

So as I understand it, there is no owner?

Below is the statement I use to create a user in the Master file when creating a company users. I did not see an option to create a reference BO but will try that in a few.

The second problem I have which was another post was the password doesn't get updated in the new Object.

If I can get these two pieces to work, the tenant system will work great.

Note:AllTenantUsers (AllSystemUsers) is master login list.

If NOT(EXISTS AllTenantUsers WHERE (AllTenantUsers.EmailAddress=MainCompany.Email)) Then
CREATE AllSystemUsers WITH AllSystemUsers.EmailAddress=MainCompany.Email,AllSystemUsers.FirstName=MainCompany.FirstName,AllSystemUsers.LastName=MainCompany.LastName,AllSystemUsers.LoginName=MainCompany.LoginName, AllSystemUsers.Password=MainCompany.Password, AllSystemUsers.AccessLevel='CompanyAdministrator'

So you are saying add the reference in here. Will take a look. Additonal feedback appreciated now that you can see what I am trying to do and what do you think about the password issue?

Thanks,

Mark

Markfre1

Changed the company to non multiple and added to the rule below.

AllSystemUsers.MainCompany=MainCompany.AllSystemUsers.MainCompany

and tried

AllSystemUsers.MainCompany=MainCompany.AllSystemUsers

Did not work. Could you clarify your explanation.

Thanks,

mark