having problem with bound columns in forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I just posted this in another area but think it will be best answered here...

I am trying to get the text value of a table in a form. Here is what I have:

table1: id#, item (text), code (text)
table2 (main table): item (number lookup for item, table1), and code
(number lookup from code, table1)

Form: Data is from table2: I have drop down box for item. I want it to auto
populate the text value in code field when item value is selected, which it
does, but it gives me the ID value "behind the scenes". In other words, if I
try to grab the value to use in a code block, it grabs the ID value and not
the text value.

How can I get it to use the text value?
 
Meilani

Table1 defines the Item and Code that is associated with each id#. (By
the way, as an aside, it is not a good idea to use a # as part of the
name of a field). It is therefore incorrect to try and recreate this in
Table2. All you need in Table2 is one field to hold the id# and you
automatically know the associated Item and Code. In order to return the
text values for the Item and Code on your form, there are several
approaches... but they do not include duplicating the data into both
tables. Possibly the simplest is to base the form on a query which
includes both tables, joined on the id# field.
 
Back
Top