Bound columns

G

gatabrava

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?
 
J

Jeff Boyce

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
 
Top