Extending data table

[geocan2006]

I have my inventory table residing in an accounting software which I can link it to Access, however the data table is limited, the reason I need to do this is because I need to link the extended table to use in website table so whenever I change the price in the accounting software it will also change price and available quantity. How can I structure it, I am ok in creating query’s but not good in sql
Thanks

[ranman256]

Queries are the easy way to make SQL.

[June7]

Available quantity should be calculated when needed based on raw data transaction records, not saved to table. Review http://allenbrowne.com/AppInventory.html