Replacing Data

Legacy Poster

• 2015年02月27日 09:13

Hello,

 

I have a problem with automaticly replacing data. I have a database which has a collumn located at 'DB1.ID'. This collumn contain many different numbers which are corresponding with 'DB2.ID'. The collumn 'DB2.ID' also contains the real names of the numbers. So I.E. the value of 'DB2.ID' is equal to 'BMW'. In Access the databases are corresponding so when the database is 'running' the value of 'DB1.ID.1' changes to 'BMW' using a script. I succeeded to add both databases to one database in Bartender but it doesn't align well. I.E. ID1 is in the same row as ID293 it's not possible to order them based on there number because DB1.ID has the same value's multiple times so there are multiple 'BMW' outputs. Has anybody got an idea how to replace or connect the data to each other based on their ID? It takes to much time to use the 'Search and Replace' function in Bartender because there are 100+ value's.

 

Thanks in advance,

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • 2015年03月02日 13:06

  Am I understanding the you are trying to connect two databases into one label document?  This is a standard feature of Bartender and needs to be done in the database connection setup form.  There you can add as many databases as you like and specify how those databases joined.

  0

請登入寫評論。