0

I have a number of tables that are linked by a common field called StockCode. The StockCode contains maybe one and sometimes 2 single quotes. When I try to read the related tables using the StockCode as the key I get an error.

E.g.

Table: Stock, field: StockCode = Earl's Stock
Table: Sales, field: StockCode = Earl's Stock

If I read the Stock and try to find the StockCode on the Sales Table I get an error.

theduck
  • 2,589
  • 13
  • 17
  • 23
Earl Harrison
  • 1
  • 1
  • 1
    Please always include error messages in your question. – eike Oct 28 '19 at 14:23
  • 1
    Similar question already answered here ... https://stackoverflow.com/questions/1912095/how-to-insert-a-value-that-contains-an-apostrophe-single-quote – John Sheridan Oct 28 '19 at 17:36

0 Answers0