2 Replies - 1035 Views - Last Post: 29 June 2014 - 04:06 AM Rate Topic: -----

#1 iskibidi15  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 12
  • Joined: 04-June 14

How to relate two tables in MS Access

Posted 25 June 2014 - 07:40 AM

I'm currently creating Inventory System using VB6 with MS ACCESS for database using the Adodc and Datagrid commands. This project is for school requirement.
I have two database tables which are the STOCKS and ROOMS. I can easily Add/Edit/Delete Items in Stocks and Rooms but my problem is the relationship between the STOCKS and the ROOMS. What I really want to happen is when I add Items on Rooms, that Item will be deleted on stocks. Please help me :(

Is This A Good Question/Topic? 0
  • +

Replies To: How to relate two tables in MS Access

#2 iskibidi15  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 12
  • Joined: 04-June 14

Re: How to relate two tables in MS Access

Posted 29 June 2014 - 02:20 AM

response please :(
Was This Post Helpful? 0
  • +
  • -

#3 andrewsw  Icon User is online

  • Fire giant boob nipple gun!
  • member icon

Reputation: 3465
  • View blog
  • Posts: 11,753
  • Joined: 12-December 12

Re: How to relate two tables in MS Access

Posted 29 June 2014 - 04:06 AM

Quote

What I really want to happen is when I add Items on Rooms, that Item will be deleted on stocks.

This isn't a natural behaviour for a database so, when you add Items to Rooms, you'll have to remember their item-numbers and use these to then run a separate delete-query against Stocks.

This post has been edited by andrewsw: 29 June 2014 - 04:06 AM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1