UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> First Form - Combo Box Values From Different Table, Access 2010    
 
   
NimishParikh
post Dec 3 2017, 07:24 PM
Post#1



Posts: 199
Joined: 30-November 10



Hi Friends,

I have plety of table where I used to enter data directly. However, I found that it is very difficult to decipher them because of the codes.

Now I am trying to create really functional forms (for the first time) to better visualize my data and understanding. I have concept of form and their features like master / detail relationship by reading but have never implemented in real life seriously and I am looking to be primed from experienced users. Few elementary forms I developed did not take me far but now I am seriously thinking to take deeper dive in this.

The tables are as follows -

CODE
tblAlias
========
AliasCode PK
ComponentGroupCode
ComponentSubGroupCode

tblComponentGroup
=================
GroupCode PK
GroupDescription

tblComponentSubGroup
====================
GroupCode PK (Foreign key to GroupCode field of tblGroupCOde
SubGroupCode PK
SubGroupDescription


What I need on a form is -

A text box bound to a field AliasCode(tblAlias)
A combo box bound to a field ComponentGroupCode(tblAlias). Here I need to display GroupDescription from tblComponentGroup and corresponding GroupCode is picked up in the background.
A combo box bound to a filed ComponentGroupSubCode(tblAlias). Here I need to display SubGroupDescription from tblComponentSubGroup and corresponding SubGroupCode is picked up in the background. Also, I need to see in this combo values corresponding to GroupCode only.

It may be simple, but, being new to the forms it sounds bit difficult for me.

Nimish
This post has been edited by NimishParikh: Dec 3 2017, 07:30 PM
Go to the top of the page
 
NimishParikh
post Dec 3 2017, 08:02 PM
Post#2



Posts: 199
Joined: 30-November 10



Success. I could achieve first two steps of the form.

QUOTE
A text box bound to a field AliasCode(tblAlias)
A combo box bound to a field ComponentGroupCode(tblAlias). Here I need to display GroupDescription from tblComponentGroup and corresponding GroupCode is picked up in the background.


Working on third step late Sunday evening. dazed.gif

Nimish
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    16th December 2017 - 08:07 AM