473,322 Members | 1,540 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

How to make a textbox show information from an outside table based on a reference ID

2
I have a Form that requires user updated information. It is based off a query including 2 tables. One of the tables has an ID that refers to a 3rd table. I would like to show a reference textbox from the 3rd table [partnumber] based on the 3rd table's ID from the form's record. The form view is a continuous form also so multiple records are shown at a time. Is this possible?
Jan 8 '14 #1
2 1092
zmbd
5,501 Expert Mod 4TB
JMTOP:
Depends on how you have things designed.
Please post your SQL for the form's recordsource
Please remember to format the SQL script using the [CODE/] button in the toolbar.

Also, I shold note, that it's not normally a good thing to store the same information in multiple tables, there are exceptions to this rule; however you might read thru:[*]> Database Normalization and Table Structures just to be sure that you are using the Database for more than just a spreadsheet. (^_^)
Jan 8 '14 #2
JMTOP
2
Here is the SQL for the form's source
Expand|Select|Wrap|Line Numbers
  1.  SELECT tblReview.*
  2.    , tblLogistics.*
  3. FROM tblLogistics 
  4.    RIGHT JOIN tblReview 
  5.       ON tblLogistics.ReviewID 
  6.          = tblReview.ReviewID;
tblReview refers to an ID from another table that lists general information about parts (tblWorking) the logistic guys need info from tblWorking (hence the textbox) to complete the logistics after the review.

I don't need to store any information in multiple tables I just need the users to reference it (non editing) to complete their work in the form without jumping from form to form.

Does that make it more clear, or more muddled?
Jan 8 '14 #3

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

Similar topics

11
by: Jack | last post by:
I want to display a table on a page based on whether a button is pressed or not. I'm new at php so I'm sure I'm making a basic mistake. Here's what I am trying. My thought was that $show_summary...
2
by: SR | last post by:
Can someone please help me interpret this result set below and suggest on way I can speed up my table? What changes should I make? DBCC SHOWCONTIG scanning 'tblListing' table... Table:...
7
by: Mad Scientist Jr | last post by:
Through messing around I got IE6 (win xp) to show/hide a table row. I gave my <TR> an ID of "trRow" and trRow.style.display='none'; hides it trRow.style.display='block'; displays it (will any...
5
by: Ray | last post by:
Hi, I was wondering if anyone has any idea how this can be done. I am trying to show/hide navigation links based on server names or ip addresses. So if, someone visits a particular url/ip address...
5
by: das | last post by:
hello all, this might be simple: I populate a temp table based on a condition from another table: select @condition = condition from table1 where id=1 in my stored procedure I want to do...
2
by: elkeseltza | last post by:
Hi I am supernew at all this webstuff and am learning as I go. One of the major problems I have already encountered on numerous occasions is that IE and FF don't display the same way! Latest...
3
by: Mirnes | last post by:
Hello! How can I show data outside of data controls (gridview, listview etc.). I want to build CSS menu with data from database table and that is the reason why I need it outside of any data...
3
by: jayo17 | last post by:
I have access 2003 on Windows XP. So what i am trying to do is edit a record in a table based off of a specific combo box selection. I know how to make the combo box change the values in a table...
16
by: Malcolm McLean | last post by:
I want this to be a serious, fruitful thread. Sabateurs will be plonked. Table-based programming is a new paradigm, similar to object-orientation, procedural decomposition, or functional...
1
by: Michael Potts | last post by:
I am trying to retrieve information from a table based on a column name (ex. 6187A1) and the I only want to retrieve the information from that column that has a value of "1". I will use this...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.