Populate field in a table from another table...
In the tblInvoice one of the fields asks for JobNumber. I would like to, based on that JobNumber, to look up tblProject for the corresponding ContractValue and auto fill a field in tblInvoice with that ContractValue.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
I have a table with list of lab technicians (labtechs). I have a table (Process) with a process where I would like to add a field with the labtech but only from the list in table: Labtech.
Instead of making a drop-down in the Process table that links to the Labtech table, I would like to populate the labtech field in the Process table via a Form where I only have the choice of labtechs from the Labtech table. So basically I want a drop down in the form but NOT in the table.
I have an employee table that shows employees and some basic information about each of them. This table has an employee ID field that is not an autonumber but it is unique to each employee (10004928).
I have other tables that also use that same field and I want the first and last names to auto populate based on the main employee table. These other tables are tracking OT and Vacation time used.
How do I make the later tables auto populate the name fields when you key the employee ID?
Table A has 3 fields and I want to query Table B based criteria in Table A, field 2 and 3. SQL as follows
SELECT [Table A].[Field 2], [Table B].[Field 2], Sum([Table B].[Field 2]) AS [SumOfField 2]
FROM [Table A] INNER JOIN [Table B] ON [Table A].[Field 1] = [Table B].[Field 1]
GROUP BY [Table A].[Field 2];
I keep getting the error "You tried to execute a query that does not include the specified expression <Table B Field 2> as part of an aggregate function. (Error
Table A - Webinars (Webinar ID, Webinar Title and Client)
Table B - Sessions (Session ID, Date, Webinar Title, Time, Facilitator, Session Occurred, Reason, Conference Call) [Webinar Title I used a look up field and just select the corresponding Webinar Title and it works nicely]
Table C - Users (User ID, Status, Prefix, Last Name, First Name, Email Address, Component, Role and State)
Table D - Registrants (User ID, Session Date, Webinar Title, Attended).
So in Table D I would like to add Role and Component, so when I select User ID #1 the Role and Component Field populate with the info based on Table C.
Does that make sense is there a way it can be done simply
I'm having trouble getting the table to populate the second ID field based on what is selected from the drop-down in the first ID field.
Person table (ID, FirstName, LastName, SSN, HRID)
Orders table (ID, PersonSSN, PersonHRID, etc.)
If I populate the Look-up field of PersonSSN as 'Select SSN, HRID from Person' (use column 1 as value),
how do I get the HRID field to populate when someone selects a SSN value from the Person drop-down?
And the follow-up, can I get the same thing to happen in reverse (I.e. populating the PersonSSN value when the customer selects an HRID from the PersonHRID drop-down)?
I'm hoping someone understands what I just wrote,
I am using a DLookup function on a command button to populate a field on a form with value from another table. However it only seems to populate the field with the top value from the table.
Below is the code
Private Sub Command111_Click()
Me.lngEncrpytion_Password = DLookup("[Password]", "[tblpasswords]", "EncryptionID = EncryptionID = '" < myknowngoodpassword >
I have a second table where I enter one of the procedure codes (looked-up from my original table/typed in), and I would like the value associated with this code in the original table toauto-populate a second field "after update".
Is there a way to make this field pull from the same table as the procedure code is pulling rather than having to type hundreds of "If/Then" statements in VBA?
The content of field#1 is a pick-list lookup from a separate table. The other table also holds the look-up list I want to use to populate field#2. The relationship between fileds 1 & 2 is direct. Sounds simple ? It's driving me nuts.
I've tried using DLookup and I'm stuggling.
Can it be done using DLookup or another Built-in function or do I need more complex code.
Can anyone tell me what the syntax for the Dlookup function in the above scenario would be . and where should I put it ? "on click" "after update