Table Issue

[Ripley]

Hi, im using access 2003, and i have a slight problem.

I have a table, tbl_Members.

The table contains many fields, of which all other relationships work fine, but on of the fields requires a lookup from the same table, tbl_Members.


Is there anyway i can do this?

 

[boblarson]

Well, for one - you should NOT use lookups in tables. They will only cause you grief later. And, yes you can do what you need to do from forms.

 

[Ripley]

Ok, but i need a way of storing the value, thus it must be stored in the table somehow

 

[boblarson]

What you do is:

1. Create the form based on the table
2. Change the format of the text box for the field you need to lookup to combo box
3. Set the rowsource of the combo box to the table you are in and the field that you need to lookup. Since you are changing these manually, you need to make sure to set the right number of columns and the widths.

Does that make sense?

 

[Ripley]

All is clear, many thanks!