Thread: Create association between tables

Hello,

I have a problem that's little tricky to describe. I'll give it a try. I download a table of data from a database using ODBC access. Let's say

ID; Name ; Surname; Salary

Everytime a person is added and I refresh the table, it basically puts him in the first line and all the lines move one line down (that's ok, something I'd expect that). Nevertheless, if I for example add manually a new column which is not from databaseNumber of Kids. So the table looks like this

ID; Name ; Surname; Salary;Number of Kids

when I refresh and new person was added, the number of kind column is not associated with the rest of the fields. So all the fields are moved one line down except manually added column Number of Kinds.

Question: How can I create this association that will ensure the manually added columns move the same way as those downloaded from the database?

I hope you'll help me.

Thanks

Roman

I would reccomend you are going to have to manage a separate list that has ID and Number of kids in your spreadsheet. You can do a vlookup on ID to return the number of kids to that column. That should open up some ability to sort/filter without screwing up the rest of your data.

This is assuming you are using excel.

There isn't anything to stop a record from being deleted down the list and offseting your data down the list.