linking a field in one table to a recordset in another table????

[dtgorm]

Ok, i have a table, [tblMusicProfile], that has a field called "instruments".
In another table, [tblMusicInst], the instruments are listed and for each instrument, there is either a "1" for yes or "0" for no.
In the tblMusicProfile, the instruments field would have a string of numbers that is brough over from tblMusicInst such as 1011101...
That is what I am wanting to do...
Now how do i link the field in one table to a record in another table???

 

[RFRAN]

YOU CAN "JOIN" THE TWO TABLES:

SELECT COL1
FROM TABLE1, TABLE2
WHERE TABLE1.COL1 = TABLE2.COL1
ORDER BY TABLE1.COL1

 

[rush]

Can you explain in more detail what you want to accomplish by "linking" fields in one table to another. I think if we knew what you were trying to accomplish it would be easier to suggest something. Linking fields can be done many ways for many purposes.

Describe the fields in the first table as well as the main fields in the second table and how you want them related.

Bill