query one field from another table

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Other Forums

MS Access

query one field from another table

Author

Topic

nicka
Starting Member

28 Posts

Posted - 2002-11-05 : 13:56:04

Hi

I have one table (tbl_Products) which is a list of products by ID as follows

ID ProductCode
1 A0125
2 A0234
3 A0465

In the second table (tbl_Map) I have the following fields:

ID Map
1 1,2
2 1
3 1,2,3
4 2,3

Where the Map field is reading the ID records from the tbl_Products. The Map fields should display a dropdown of the appropriate "Productcode" records.

I am looking for the query to read the info from the "Map" fields into a drop down (a new field)

Help

ID

AndrewMurphy
Master Smack Fu Yak Hacker

2916 Posts

Posted - 2002-11-06 : 06:42:36

I smell a poor design here....

any chance that you can change the tbl_Map to be something like...

Id, Sequence, FKproductID,
(ID+Sequence make a priamry key)
with data

1,1,1
1,2,2
2,1,1
3,1,1
3,2,2
3,3,3
4,1,2
4,2,3

this should allow you to establish a simple relationship between the productId and the FKProductID columns....

Otherwise I think you are going to be up a creek without a (good) paddle....

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources