Associate to fields

[mike wild]

I have been pulling my hair out over this one.

Table One has 4 fields, 2 of which are called Logo, and company.

I am trying to "connect" them both to gether, so that if the user selects "john's hotel" in a form then the corresponding logo will link.

I beleive the i need to split the tables, and with a query join then back - but what type of query and setting.

Any suggestions?

 

[Mile-O]

Does the field Logo have an actual bitmap file (bad) or the path to the file on the network (good) ?

 

[mike wild]

It has the path to the file name. The logo field is a simple text field of up to 200 charecters.

records 1 is
LOGO: c:\datashow\images\BT.gif
COMPANY: British Telecom