2 databases from 1 listbox?

[DragonRose]

Hi all,

I have 2 Access databases;

Db 1 & Db 2, On the form is a list box which is data bound to DB1 'MainName', and a bunch of textboxs which populate from the record selected from db1 in the listbox.

In DB1 the 1st column is called 'MainName' and in DB2 the 1st column is also called 'MainName'

Now what im looking at is when the item in the listbox is changed, the record in the second database which has the same String in the 'MainName' column is also selected.

The route to take that i can see is having both databases added to the project , and have the listbox apply a filter on database 2 based on the selected item.
(im using 2 separate databases as when my project updates the DB1 also updates, but DB2 contains the users own strings so i don't want that to update as it would lose all there saved strings.I dont know much about lookup tables etc but they must all be in the same database right? so that rules them out, due to the update issue.)

Before i take this route tho, is there a better way?

[Shaggy Hiker]

I can see the point in having two tables in the same DB, but don't see why you have two entirely separate DBs. It seems like you will just end up fighting with that. Two connection strings, potentially two locations, and so on.

Still, you aren't filtering the database itself. At most, you would be filtering a dataset built from the database, and that does seem like a reasonable way to go.

[DragonRose]

but don't see why you have two entirely separate DBs

Im using 2 separate databases as when a new version of my project is released, it has a new version of DB1, if the personal strings of the users are also saved in that DB1 then every-time they install a new version of my app, there strings will all be lost and have to be entered again.