Combo Box in Table

[PL]

For Access 2003.

1) In Table, I want to use a combo box with the options from another table,
what the syntax I should enter for the row source?

2) In Table, I want to use ID for the field, but want the combo box options
to be the names connected with these ID, what's the syntax?

Thanks

 

[KARL DEWEY]

what the syntax I should enter for the row source?
I have never seen a table with a row source.
Fields in a table can be lookup type but all I have read is that they are
bad neqs. I see many post where they have unsolvable problems.

 

[RoyVidar]

For Access 2003.

1) In Table, I want to use a combo box with the options from another
table, what the syntax I should enter for the row source?

2) In Table, I want to use ID for the field, but want the combo box
options to be the names connected with these ID, what's the syntax?

Thanks

1 - technically you can do that either by using a lookup-wizard, or enter
the lookup tab for the field, but you do not want to do that. The
following page http://www.mvps.org/access/lookupfields.htm sums up most
of the reasons why you do not want to do that, and why most of us do not
use this "feature" at all.

Use combos on forms in stead. You're not, or at least, you should not,
allow your user access to the tables anyway, so combos on forms is the
preferred method

 

[John W. Vinson]

For Access 2003.

1) In Table, I want to use a combo box with the options from another table,
what the syntax I should enter for the row source?

2) In Table, I want to use ID for the field, but want the combo box options
to be the names connected with these ID, what's the syntax?

Thanks

You can do this on a Form... but to my knowledge not in a Table. The Lookup
Wizard is *very* limited. As noted elsethread, you should probably NEVER use a
Lookup Field in a table, nor should you ever use a Table datasheet as a means
of interacting with your data.

Instead, use Tables for their real purpose - storing data - and use a Form to
interact with the data. It's very easy to create a combo box on a form - the
toolbox wizard gives you everything you need.