Hello! I hope I'm posting this is the correct subforum. I have a layout (based on the table patient) in which I am wanting the user to be able to enter a new patient information. I have another table called referrer (which is linked to patient via a pK fK relationship).

I have a field tool box set up to auto-complete and use the referrer::lName box as the auto-complete field. This appears to work great, and seems to auto-complete and fill in the name. The issue is that when the user saves the record, it creates a new record for the referrer (instead of just using the existing record for the referrer). I hope this makes sense. I'll try to clarify it a bit more:

Let's say the referrer's last name (lName) was Smith. The user would type in 'sm' and it would come up showing Smith (since a record for Smith already exists). When the user then leaves the screen / record, FM for some reason creates a NEW referrer::lName record for Smith, and doesn't use the existing one.

Any idea what's going on here?

Thank you!!!

This question is very similar to a posting a couple of days ago, both in terms of the problem and the scenario. You might want to take a look at this thread:

FM Forums topic #370137