Mysterious Contact Creation

[Ryo_Saeki]

I've managed to make it this far in my database, but I've run into an issue that my friends and I can't seem to figure out.

Any time I create a new employee record, it automatically creates a new company with it. The idea was to have multiple contacts in one company that you could view in the employee tab. This would eliminate having to switch back and forth between windows.

You'll see by the format of the attached zip file, that things should be fairly self explanatory. I'm not sure what it is that I'm doing wrong. Can anyone spot it and help me out?

P.S. - Be sure to delete all the records first in both the company and employee table. Then try adding a new company, and employees. Once you see the employee, take a look at the company page again...now you'll see companies with no names.

OMIC_Client_Database.zip

[LaRetta]

In OMIC Contact Persons database, you have 'Allow Creation of OMIC Companies' on the COMPANY side. This is okay but your relationship is based upon the Company ID. This means that, when you type into the OMIC Companies::Name field (on your OMIC Contacts layout), it inserts a new CompanyID (and company) into the Companies table.

What you need to do is base your Clients value list on the Company ID; change it to a pop-up instead of a drop-down, and include showing Company name in the value list. When you then select the CompanyID, it won't create a new one. But if you type directly into the Company Name field (you must check in pop-up settings to 'include other') it will then create a new Company record and insert the new CompanyID automatically into the Companies table.

It probably sounds a bit strange ... or maybe it's just the way I explained it but, if you play around with it a bit you will see what I mean. :wink2:

[Ryo_Saeki]

I'm still too new to this. It's not totally making sense -_-"

[Ryo_Saeki]

Yeah, this is still not making any sense. Can I get some more advice, or maybe another method of looking at it? At this point, it almost seems like it's doing the exact opposite of what I want it to do.

[Fenton]

When you are just beginning, I would advise that you only turn on [x] Allow creation of related records on the "child" (contacts) side of the relationship. Only create new Contacts from the Company table's layout, in a portal. You could also have a drop-down of the CompanyID (not the name; but a value list showing only the name; which is an option for a Value List).*

I also took the liberty of shortening your names. It's confusing enough without long superfluous (in my opinion) info in names.

*Requires that the field used as the 2nd field, hence sorted, indexed field, be unique to its table. Otherwise on the 1st will ever show in the value list. Best to validate the field to be sure.

OMIC_Clients_fej.fp7.zip