Newbie to access and asking for help with relationships

[WHAMMER]

I am new to the forum and could use some help. So I am trying to put in information into one table by grabbing information from another. so I have a main records table that will have all the information that was inputted from a form.






now when I input all the information from the form the part description is blank. I believe there is a way using relationships that when I put all the info in it will automatically put in the description. any help will be great thanks

[pbaldy]

Typically it would be a mistake to store the description there:

http://www.baldyweb.com/Autofill.htm

[WHAMMER]

Typically it would be a mistake to store the description there:

http://www.baldyweb.com/Autofill.htm

Sorry I'm confused. maybe I didn't explain well enough what I am trying to do. But, from what it sounds like from that site I have tried that before. In the combo box I have 3 columns and it only keeps the first column and it doesn't work that way I thought it would. so lets say on the form I have the part number and when I put it in and finish it stores the info on the main records page. then on there the part number gets filled and then a field next to it that says the description. i want it to grab the description from the excel page that it is linked to and put that in the description field on the main records page. is that possible? thanks

[pbaldy]

A combo will only save the bound column. If you want to save the description (I wouldn't), you can use the second method from that link.

[orange]

WHAMMER,

To help the readers understand your problem/opportunity could you give us a description of WHAT you're trying to do in a few sentences. Perhaps readers will offer options/suggestions once they get a feel for your situation.

Perhaps you could include a jpg of your tables and relationships.

[WHAMMER]

yeah sorry, Im new at making a database from scratch I have altered other databases that have been done so this is a little hard for me.
so I have a form that I enter employee name, part number, start date and time, and I have a table that all the information from the form goes to.
and as far as relationships that is where I think I need help at. I try making a relationship and nothing changes. and when I select a row in the dropdown it just shows the part number not description. I think this explains what I want to do. thanks for the help

[pbaldy]

I understood the question, but apparently you're not understanding the answer. The combo will only save to one field, not both. If you want to save both, try the second method in my link. You can hide the bound textbox if you want.

[orange]

So, in plain English, your database is primarily for recording information related to an Employee "inspecting" a Part. I see Start and End times and the form Title says Inspector. If that is true, please tell us exactly WHAT the issue is. If I have misunderstood, please revise as necessary.

[WHAMMER]

Yeah it is basically a start and finish report for inspection parts. my issue is when I put in the part number on the form it dosn't copy the description with it onto the main records table. Pbaldy sorry the link is kinda hard for me to understand. this is my first time doing a database from scratch i haven't had any training on it. I know the combo will only save the first field on the form that not a problem I just want it to take the item number info move over to the main records table and fill in the part number then fill in the rest of the blanks related to that part number

[June7]

The point trying to be made is that the description SHOULD NOT be saved onto the main records table. Only the part number should be saved (if the part number is defined as the primary key field). Accept that and there is no issue.

Also, people name parts should be in separate fields in Inspectors table and do not save the full name into main records table, only the InspectorID.