Topics Search

Auto-fill one field from another table

Auto-fill one field from another table
Views: 96
I am working on Access 2007.

I have two seperate tables (called inventory and job log) and they have a few of the same field items (number, name, style 1, style 2, and area).

I would like the job log table to autofill the name, style 1, style 2, and area when you type in the number when logging a new job (pulling this information from the inventory table). It has to be fairly straight forward but I am having trouble trying to make this happen. Could someone please help, I am sick of flipping between tables to fill in the information
Sponsored Links:

More topics

 

Auto Fill Fields in a Form using a Combo field

Preview
I am trying to auto-fill address info from a combo field. I'm using a select query on a table for the information. It appears to work for the first field (Firm Address1), but then stops working on all the other fields.
 

Auto Fill Fields in a Form using a Combo field

Preview
I am trying to auto-fill address info from a combo field. I'm using a select query on a table for the information. It appears to work for the first field (Firm Address1), but then stops working on all the other fields. Any idea what's going wrong
 

Auto calculate field - extract certain information

Preview
I wonder if it is possible to generate a new field which auto fills values with everything between brackets "(xxxxx)" in the source field?

I have a field with records like abc(xxxx) and I want to auto fill another new field only with xxx
 

Auto-Fill text fields in the form

Preview
is there a way to have a form set to either auto populate fields based on the FIRST FIELD? For example: if the user type in the STUDY ID, the other fields like (first name, last name etc.) are auto-populated/auto-filled?
and if the STUDY ID is new and not in the table, then the users simply fill in all the fields/complete the form and save?

And I would also like a message box to show when I am typing the STUDY ID that would say something like: this person is on the system already. Click YES for this person and NO to add the user?.
 

Auto fill in value based on two fields

Preview
I am creating a user input database with a table name “tblOutput”. It several fields such as OrderNbr, Oper, PartNbr, Machine, Area, UserName, InputTime and etc. I also have another table for reference calls “tblOrderRef which has field such as OrderNbr, Oper, PartNbr, Machine, Area.

I would like to auto fill in the values for field PartNbr, Machine and Area based on the OrderNbr and Oper the user input. I need help with create reference query auto fill those field in either table or Form.
 

Auto Fill Field

Preview
I would like to auto fill a specific field for every new reord of a table with the same value. I have a table that includes a field "project Number". When you add a new record the same Project Number needs to be included for every record.

I have tables for separate projects and need to compare information from 1 project table to the other project tables.
 

Auto-fill field not saving to table

Preview
with this:

In the form, there is a field that gets filled in automatically by what is entered into two other fields on that form.

The information that is being automatically generated in that field is not saving to the table.

Example:

Field 1: Meeting Type
Field 2: Meeting Year
Field 3: Auto-fill field (starts out blank)

Field 1: I choose "Annual Meeting" for the meeting type (this puts AM into Field 3)
Field 2: I choose "2010" for the meeting year (this adds 10 into Field 3)
Field 3: "AM10" is now what shows in the field

I save the data base. I go look at the table and there is nothing in the Field 3 column, when there should be "AM10."

Any ideas about how to get it to save that info in the table
 

Design View = Text 6 Char =Next Column

Preview
My Table has the following fields:
Example:
Field A = aaabbb
Field B = aa-aaa
Field C = aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

When I fill the fields I want them to advance to the next field if they have the maximum characters, 6 char in Field A & 5 Char in Field B. I have been able to auto enter the "-" with no problem in Field B. I only use Field C when I want to make a note. I'm not using a form view. I'm trying to avoid unnecessarily keys to continue.

Work Flow:
Field A - 6 char auto advance to Field B
Field B - 5 char auto advance to Field A
Field C - I use mouse to select since it's a rare event.
 

Auto fill data (number) between tables

Preview
I created a database to track a group of records (people). I couldn't figure out how to auto number the primary key to a random unique number that was less than 10 digits so I generated a list of random numbers and just use the next number off the list as I enter the next person which works OK- but I have to put that number on each table as the ID number to relate back to the Primary key and it seems that I should be able to have those auto fill with the entered number. Is it possible to have the number typed in "table 1" (people) primary key auto fill onto each of the other tables as an ID number?
 

Auto fill field upon New Record selected

Preview
I have a field in a table ( Clients ) called Clients_Client#, which is a text field. Each year we start a new group of clients numbered as follows:
and so on.

I would like to fill in this field automatically when a new record is selected to avoid typos and duplications