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?