linking a field in one table to a recordset in another table????
linking a field in one table to a recordset in another table????
(OP)
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???
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???





RE: linking a field in one table to a recordset in another table????
SELECT COL1
FROM TABLE1, TABLE2
WHERE TABLE1.COL1 = TABLE2.COL1
ORDER BY TABLE1.COL1
RE: linking a field in one table to a recordset in another table????
Describe the fields in the first table as well as the main fields in the second table and how you want them related.
Bill