Description Field

G

Guest

I have a database that is currently linked to 2 tables.

I want to allow the description field to be filled from either table
depending on whether the informaton exists. At the moment the field control
source is set to [description] from [table1] which works fine. If i then use
a part number or txt search for items on table 2 i get a blank field or
#name, as the same field in [table2] is [description1] is not set as a
control source.

Can anyone advise the best way round this problem??
 
R

Rick B

Why do you have the same field for a duplicate item in two tables? A
properly built relational database would only store the description in one
table. The other table would then link to that table.

What are your tables and fields?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Union and group, then count 1
Two tables, one form 3
how to lookup for a value in a table? 3
Replace text with related number 1
Cascading relationships 4
How to change value of field in one to many relation ship 2
Suggestion for Append 3
use update query in a table of one-many 2

Top