Auto Data Entry

[CTQE]

Hello All,

I was hoping someone could tell me the correct method of performing my intented function.

I would like for Access to Auto Input data from another table based on one entry in the current table.

Table 1 consists of Field 1 (Part Number), Field 2 (Serial Number) & Field 3 (Description).

Table 2 has Field 1 (Part Number) & Field 2 (Description).

Based on the info from table 2, how do I get the program to auto input Field 3 from table 2 (when I type in Field 1 in table 1)?

Thanks in advance

 

[georgedwilkinson]

Does your intended function have anything to do with people entering data on a data entry screen? Is it a batch function?

More info, please.

 

[CTQE]

data entry screen

(Thanks for the "speedy gonzales" like reply!)

 

[georgedwilkinson]

2 approaches:
1. will you be flattening the data, i.e. all the fields you need to enter data for are in one section of the screen?
2. Will you be using a sub-form, entering many of the table 2 entries for each table 1 entry?

Not knowing your system, but having a deep understanding of the way the world works, I would suggest there is a 3rd option:
3. Having multiple table 1 entries in a subform for each table 2 entry (in a main form).

Please show us your database relationships.

 

[CTQE]

Table 1 is a sub form to the main table (Table A).

The data entry process is as follows:

Step #1 Enter the part number

Step #2 Enter the serial number

After Step #1 is defined, I would like Field 3 (Description) to popluate accordingly.

 

[georgedwilkinson]

Let's try again...I'm getting confused.

Could you give a name to your tables and re-state your problem with the name of the tables?

What I envision:
tblParts
ID
PartNumber
Description

tblSerializedParts
ID
PartID
SerialNumber
MoreNotesAboutThisInstanceOfThePart

with PartID an FK from ID in Parts.

tblParts would be in the main form. tblSerializedParts would be in the sub-form.

Is that correct?

 

[CTQE]

Thanks for your patience so far!

All I'm interested in, is for my form to auto "fill in the blanks" based on one entry.

One table is setup with fields named Part Number, Description and many other fileds.

Another table already defines what the description is based on the part number.

For example:

Part number: A
Description: Optical Comparator

Part number: B
Description: Fiber Cable

In my form, I would like to enter the Part number & have the description auto populate.

Does this help at all?

Thanks a bunch!!!

 

[georgedwilkinson]

Does this help at all?

No. You've not answered my question.

I'd be happy to take a look once you give me the information I need to help you (as indicated in my post above).