Bound columns

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

Guest

Hi, I Have a form with text box with 2 field - fDesc; aDesc. fdesc is the
bound column and displays in the text box. But I also want to store aDesc in
the table. How can I also have the second column bound?
 
Don't do it! Access is a relational database. Unlike Excel, it is rarely
necessary to store the same data (e.g. your [aDesc]) in more than one table
(and there are some very good reasons NOT to do it).

Use a query to join the tables to display [aDesc] for a given record.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi, I Have a form with text box with 2 field - fDesc; aDesc. fdesc is the
bound column and displays in the text box. But I also want to store aDesc in
the table. How can I also have the second column bound?
Click to expand...

What are these fields? Are you trying to copy adesc from one table, and store
it redundantly in a second table? If so, this is generally A Very Bad Idea;
you could easily end up with aDesc being one thing in the original table, and
*something different* - indeed even many somethings different - in the second
table! Why do you feel that you need to copy it?

What is the Recordsource of this form? Where do fDesc and aDesc come from?

John W. Vinson [MVP]
 
Thank you - actually found a workaround by using Dlookup. FYI - these are
not redundant fields - fdesc = full description is derived in the form as a
concatenation of various elements; adesc = same as fdesc but using the
standard abbreviation for those elements. Each desc format is then posted to
different ERP systems.
 
Thank you - actually found a workaround by using Dlookup. FYI - these are
not redundant fields - fdesc = full description is derived in the form as a
concatenation of various elements; adesc = same as fdesc but using the
standard abbreviation for those elements. Each desc format is then posted to
different ERP systems.
Click to expand...

If you're assuming that you must store the data in a table in order to export
it, that asssumption is *wrong*. Just calculate the text string in a query and
export from the query!

John W. Vinson [MVP]
 
Back
Top