By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
457,845 Members | 1,288 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 457,845 IT Pros & Developers. It's quick & easy.

Option Group - Creating a lookup field to display text in the table

P: 579
Hi everybody,

I've searched around for answers, but the closest thing I've found referenced the Northwind database and it seems to be set up a little differently than mine.

I'm using DAPs (data access pages) for my user interface, but I'm not sure that the method will be much different than forms (except for some of the property names). I think my understanding or background knowledge on the subject is just lacking.

I have an option group that I created and I have placed 2 option buttons (Action and Other) within it. Actually, I think I may have copied them from another database, but the names and labels are all the same and I've modified the properties to fit this database.

I have changed the Value property of the option buttons to 1 and 2, respectively. Neither of these buttons has a control source.

My frame has a control source of ProblemType on a table I'm using as a container for data, called tblData_Log. I have another table, called tblProblem_Type, that has 2 problems (Action and Other) with an ID number associated to each.

When the user clicks on one of the option buttons, the value (1 or 2) should be stored in the frame, and then it should reference the tblProblem_Type to change the number into text and store it on the tblData_Log.

The help documents I've viewed on MSDN and through MS Online mention that storing a text value is possible if you refer the Value number to a separate table and make a lookup field in the table where the name needs to go. I feel like I've done this, but the value isn't appearing. Also, the dropdown box shows the ID number and the Problem, instead of just the problem.

Here's the SQL I have entered for the ProblemType field in the tblData_Log:
Expand|Select|Wrap|Line Numbers
  1. SELECT [Problem_Type_ID], [Problem_Type] FROM tblProblem_Type ORDER BY [Problem_Type] DESC;
Everyday is a learning experience and I appreciate any help you can offer...
Aug 8 '08 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,758
I'm not clear on exactly what you need to know from this.

Which bits are working as expected and, where they are not, what are you expecting and what are you seeing?
Aug 9 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.