Hi I hope someone is able to help me, I'm reasonably new to access so please excuse me if I don't explain myself correctly.
I have a data table called ConfirmationTable where the Main field is called ParentID. The ParentID is the signature ID number for multiple records that are titled SubID. Within my datatable I have fields where there is 1 ParentID number with 5 or 6 SubID records. My table Looks like below.
ParentID*****SubID*****Customer
12345********12346*****Jeff K
12345********12347*****Jeff K
12345********12348*****Jeff K
12345********12349*****Jeff K
12345********12350*****Jeff K
I am trying to create a form so that I can see the one ParentID and then have a subquery with all the corresponding SubID's in a list below the ParentID. I have tried linking the records together using the subquery function from within my form but when I go to display the records, I can see the ParentID but the SubID records will only appear individually to the ParentID or The ParentID will group all SubID's together but only show the first SubID number in the viewing list.
I tried to do a DISTINCTROW expression but couldn't get this to work. Below is how I would like my Form to display. Any Help would be gratefully appreciated. So thanks in advanced.
ParentID*****SubID******Customer
12345
*************12346*****Jeff K
*************12347*****Jeff K
*************12348*****Jeff K
*************12349*****Jeff K
*************12350*****Jeff K
Apologies if I haven't explained myself correctly and if this has been posted on the wrong section of the site
If you are interested, you can easily achieve the desired results using a Text Box and Unbound List Box.
12  2013 
Is this a textbook case of all customer details need to be stored in one table, parentid, custname,address, etc, etc
second table has parent id and subid plus data associated with subid? Link the parentid fields?
Or have I misunderstood?
Hi malcolm, thanks for the quick response
all the data is contained within 1 table called "confirmation table" already.
It's getting the data to filter on my form as shown in the above explanation. Where there's one ParentId that can link with the corresponding SubId records where all the SubId's have the same ParentId, but on the form I would only like to see the ParentId number once for the multiple record SubId's that are attached to the ParenId......
Thanks in advanced....hope I haven't confused you too much
If you are interested, you can easily achieve the desired results using a Text Box and Unbound List Box.
ADezii, an interesting idea, tried it tying listbox to query which gets criteria from textbox and requery on change. Works great, did not think of doing it that way, seems to go against the grain to repeat customer data though. Still I learnt something from it and I'm sure it will get used by me in the future in some guise or other. :)
seems to go against the grain to repeat customer data though
Could not agree with you more.
Hi guy's
Thanks for the idea. However I tried tying the list box to my query and it shows all the records from my query where as I just need to see the records with the same ParentID. I set the list box to tie into the query using the ParentId but still shows all the records from my query......I could send you a copy of my database to give either of you a better understanding of what I’m trying to achieve. Once again thanks for your help, its truly grateful as i'm getting to boiling point!
Nick
If you could send a Copy of the DB, in Access 2003 Format, that would be ideal.
yeah where would you like me to send it?? can i Upload it on to here??
Does it contain any kind of Personal Data, or Data that you do not wish to make available to everyone on this Formum?
No not really as i'll remove the address data from the tables. All the other data doesn't really matter! Unless you would like to send it to you directly??
Just to play it safe, I'm now sending you my E-Mail Address in a Private Message, you can send it there. I won't get to it until tomorrow, since it is Thanksgiving where I am, and I'm about to gorge myself on Turkey & Stuffing!
Thanks for that, I'll get it zapped over to you shortly. Again thanks for your time and I hope you enjoy your thanksgiving. I don't really do Turkey myself even at Christmas.....I’m more of a rib eye steak man myself, but none the less enjoy your feast
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Monty |
last post by:
Let's say you provide an online service from 7:00AM to 6:00PM Eastern
Time (daylight time in the summer). Is there way of showing these
hours of availability on a web page in the user's local...
|
by: Steve |
last post by:
I have a combo box which contains a list of JobStatus's which are paired,
"Description" (a string to display) and "StatID" (an Int to store). These
come from my JobStatus table.
I have a screen...
|
by: simon lee |
last post by:
Dear all,
I use VC++ to write a program for display a flash file "file.fla", However,
for displaying flash file, it sometimes become black screen and sometimes
cannot display the corresponding...
|
by: klawiter |
last post by:
Greetings,
I have a table with two columns. On my form, I have a combo field that
displays the contents of the first column. Upon selecting an item in
this combo field, I would like to then...
|
by: aburayan |
last post by:
Having a SQL table contains many columns. One of them contains integers of corresponding descriptions;i.e
1 for ready, 2 for done .... And i read the values and display the corresponding item list. ...
|
by: technocraze |
last post by:
Hi community experts,
May I knw whether is it possible to display the corresponding value of the second textbox based on the user input in the first textbox? This means that once the user enters...
|
by: technocraze |
last post by:
Hi community experts,
I am encountering a problem to display the corresponding values of the combo box into the textboxes. I have chose option 1 & 3 for this implementation but neither is working....
|
by: remya1000 |
last post by:
i'm using ASP with MSAccess as database.
i have two buttons and two textbox in my page.
when i press my first button (First month) i need to display the current month in one textbox and last one...
|
by: rn5a |
last post by:
A MS-Access DB has 3 tables - Teacher, Class & TeacherClass. The
Teacher table has 2 columns - TeacherID & TeacherName (TeacherID being
the primary key). The Class table too has 2 columns - ClassID...
|
by: Ramu528 |
last post by:
Hi friends, I am working on two tables. one table(A) stores id of another table(B).
I store id's in the table. with that corresponding 'id' ,i have to get the value given in table B. <?php...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
| |
