Okay so here is the issue. We have out sites administration buildings laid out with cubical numbers. We have a database that holds the cub numbers with the employee's name, and other information. The IT guy whats to add a column for the data jack numbers, sounds fine with me. So we add the column next to the cub number since these two items will never really change. But by adding a column there it kind of throws off the connection between the database and Acad. So we moved it to the end, which works, and the IT guys is cool with it, but I was wondering why this happens? Has anyone used db connect and had an experience like this? I haven't found an answer in the help yet, so I'm posting here as I continue to look.
Thanks in advance.
If it matters, old database set up.
Cub Numbers | Last Name | First Name
New way desired
Cub Numbers | Jack Number | Last Name | First Name