Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can a field have more than one value?
- Thread starter freebd99
- Start date
Hi Anna!
You can, but you shouldn't. It sounds like you have a couple of tables with a many-to-many relationship. If that is the case then you will need to design a new table to hold the information. Why don't you post your table designs and we can help you with the new table.
hth
Jeff Bridgham
bridgham@purdue.edu
You can, but you shouldn't. It sounds like you have a couple of tables with a many-to-many relationship. If that is the case then you will need to design a new table to hold the information. Why don't you post your table designs and we can help you with the new table.
hth
Jeff Bridgham
bridgham@purdue.edu
Anna,
Jeff is right. The way to do this is to make a lookup table with two fields. One field holds the Primary Key from one table and one field holds the PK from there other.
On my website I have posted an article by Paul Litwin that will show you not just what the rules are we use to figure this stuff out, but also why those rules work so consistently.
Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995
Take a look at the Developer's section of the site for some helpful fundamentals.
Remember to reward helpful tips with the stars they deserve.
Jeff is right. The way to do this is to make a lookup table with two fields. One field holds the Primary Key from one table and one field holds the PK from there other.
On my website I have posted an article by Paul Litwin that will show you not just what the rules are we use to figure this stuff out, but also why those rules work so consistently.
Jeremy =============
Jeremy Wallace
Designing, Developing, and Deploying Access Databases Since 1995
Take a look at the Developer's section of the site for some helpful fundamentals.
Remember to reward helpful tips with the stars they deserve.
- Thread starter
- #4
Thanks so much for your replies. The tables are Survey and Job Activities.
Basically Job Activities has two fields jobActivities, autonumber and Activities Performed, text.
Survey has lots of fields but the only field I'm dealing with is jobActivities. I created a lookup field to look up values in the jobActivities table.
JeremyNYC I read your article on the relationships and I will give it a try but I welcome more suggestions.
Thanks,
Anna
Basically Job Activities has two fields jobActivities, autonumber and Activities Performed, text.
Survey has lots of fields but the only field I'm dealing with is jobActivities. I created a lookup field to look up values in the jobActivities table.
JeremyNYC I read your article on the relationships and I will give it a try but I welcome more suggestions.
Thanks,
Anna
- Status
Similar threads
- Locked
- Question