I have a field in the Client table called CLIENT NAME which has 2 columns. The first combines the First, MI & Last Name and the second column is a unique Client ID number.

This column appears in 2 other tables which will be the many of the 1 side (represented by Client table).

In the Family form & Work History forms, the bound column is the second (the ID number). Both fields on the form and in the tables show that the 2nd column, the ID number is the bound field. YET when run, it works only in one form. In the other form, the saved filed is the first column (the name).

Any ideas?

Before you go much further with this application, I STRONGLY suggest that you separate the client name into three fields. FirstName, MiddleName, and LastName. You might also want to add a Suffix field to hold Mr., Mrs., Ms, etc. so you can address people properly if you want to write letters.

In the form that is not working, the bound column is incorrect.