Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating Query with Related fields. Answer!
Message
From
18/12/1997 07:52:51
Biju Varghese
M.H Alshaya Co W.L.L
Kuwait, Kuwait
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Updating Query with Related fields. Answer!
Miscellaneous
Thread ID:
00066852
Message ID:
00066852
Views:
63
Hi Everybody!

I had a problem in updating a query with joined tables. The problem was with the SQL I used in .RecordSource.

I was using WHERE clause for joining the tables. Just the way I used in Fox! We should instead use the INNER JOIN clause.

So, Fox' guys... watch out!

Thanks a lot for the suggestion Jay. It simply helped me a lot...

Regards,
Biju
Next
Reply
Map
View

Click here to load this message in the networking platform