Script Finds Between Multiple Files

[Sharok]

I'm doing a hotel database with the types of rooms in one file and a transaction file and other file that aren't important. i have in the transaction file five check boxes with extras like TV, VCR, etc. in the type file i have these as well. i want it so when the user selects the room type in the transaction file it will come up with the right ticks in the check boxs as well as being able to add other extras to the room during the customers day without effecting the types file.

HELP

[LiveOak]

Perform a lookup of the checkbox field from the Type file to the transactions file based upon the value entered in transactions for room type.

-bd

[Sharok]

Thanks for your help