linked tables and relationships 1

[leewisener]

I have a to database system, 1 that stores nothing but tables with all our data and the other has all our forms for updating the data via links to the other dbase.

Now, all worked well until I tried something different and I will try to explain briefy.

Using the linked table called call_input it has 8200 records by 9 different people, So in order to list just the records for a particluar person I created another table with only their name in it. I then joined the field with the name called collector to the call_input table field also called collector.

Now the query runs great and lists only the records with the person listed in the collector table. Problem is when I try to update the records in datasheet view it wont let me. If I delete the join between the two tables it will!

Any thoughts?

 

[ajdesalvo]

Remove the join and the table with the collector info from the query. Then, in the criteria field for the collector put:

In (Select [Collector] FROM [Collector Table])

Then you can update the data!

happy codeing! Anthony J. DeSalvo
President - ScottTech Software
"Integrating Technology with Business"

 

[leewisener]

Your an absolute life saver, the changes are going live tomorrow and I thought I would have to abort it.

It works great.

Thanks

Lee