Front End / Back End Question

[FormerJarHead]

Good day all,

My db has a front end / back end for a multi user environment. In the BE, I have a table with a field using a combo box. I set the control source, (Table/Query), column widths (0;1.25), column count (2) and bound columns (1). All is good in the BE. When I look at the same table in the FE, all is the same except column count. It only shows (1) which is the TableID field. The data I really need to get to is contained in the second column. Can I force the FE to mirror the data design in the BE or should I make the BE column count (1) and remove the ID field?

Thank you

[June7]

Advise not to set lookups in table. http://access.mvps.org/access/lookupfields.htm

Build combo and list boxes on forms.

However, if the table lookup is set then dragging the field from field list when designing form/report should adopt those properties (which, by they way, are useless in report).

Why don't you want the ID field? Is it not the primary key?

[ssanfu]

It sounds like you have a lookup FIELD in the BE.
I NEVER use lookup fields. Note that a lookup TABLE (good) is different than a lookup FIELD (bad).

See The Evils of Lookup Fields in Tables
http://access.mvps.org/access/lookupfields.htm

I set the control source (Table/Query), column widths (0;1.25)

In the BE, try removing the column widths values or set the column widths to (1;1.25)

Lookup fields in tables (IMO) are a waste of time. In a combo box on a form, you have to re-setup the same values as the lookup field. So you have spent double the time for no advantage. Plus, this "feature" is not supported in any other RDMS (SQL Server, Oracle, MySQL, DB2,....).

[orange]

Agree totally with June and Steve -- the field level table lookup and multivalued fields are a concoction from M$oft limited to Access. Most will tell you to avoid these constructs. Lookup tables, usually used with Forms and sometimes referred to as reference tables, have been around for a long time and have been and are used in other DBMSs.

[FormerJarHead]

Thanks to all of you for your knowledge. I will make the changes...