Those layouts are most likely still based off a table occurrence from a local filemaker table. You will have to change the layout to be based off your new SQL table occurrence and respecify each field as well.
Thanks for the reply. I now have four of the columns populated and I know the ODBC driver is working as when I change anything in SQL I see the changes in filemaker. What I don"t understand is why none of the other columns are populating.
I must have re pointed to the correct table otherwise I would not see any of the changes.
Any other ideas? gladly accepted.
I would double check each individual field. you could have changed some of the fields but not all of them.