×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Lookup Value

Lookup Value

Lookup Value

(OP)
Hey all,

Been a while since using access - so please be gentle smile

I have SQL tables and columns like this

tbl_user
Username
Firstname
Surname

Tbl_GroupMembership
Username
Groupcode

tbl_groups
Groupcode
Groupname
Owner

So effectively its a many to many relationship split with a bridge table to make it two one to manys.

Now in access data project i have some forms based on these tables. I have a main form which is the user, then a subform which is the group membership. I have made it so when you chose the groups you get to see the groupname and owner in the dropdown. However when you then save the entry with say 10 groups you cant see what those groupcodes refer to.

What i am trying to do is to add a read only field into the form that looks up the groupname from the groups table.

I just cant work out how to do it?

Any ideas?

Dan

----------------------------------------
www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

RE: Lookup Value

(OP)
Aha....

Actually it does work for the above. I simplified it.

The join from the intermediatry table to group is actually a composite key. I think this may be making the view in SQL not updateable.

Dan

----------------------------------------
www.fountain.me.uk

Be who you are and say what you feel, because those who mind don't matter and those who matter don't mind - Bernard Baruch

Computer Science is no more about computers than astronomy is about telescopes - EW Dijkstra
----------------------------------------

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close