Blank field

[jamccarley]

I have two fields on a form, PartNumber and PartDescription. As I have it now
you can look up data in either field and it brings up the corresponding data
in the other field. The problem is that only the part number shows up in the
table. The description field on the table is blank. I have tried using
relationships but they did not work. I am fairly new to access.

 

[pietlinden]

I have two fields on a form, PartNumber and PartDescription. As I have itnow
you can look up data in either field and it brings up the corresponding data
in the other field. The problem is that only the part number shows up in the
table. The description field on the table is blank. I have tried using
relationships but they did not work. I am fairly new to access.

You don't want the PartDescription field in any other table than the
Parts table. IF you want to see it somewhere, use a query... You
shouldn't be working directly in tables anyway -they're for storage,
not editing/adding data.

 

[jamccarley]

It won't show up in a query either. It is as if it is a blank field, but
there is information there on the form.