0

Hello to everyone !!!

I have a problem with a tabels in Acces.

Im making a software for minimarket and i have 2 tabels...

First Table :
Articles(IDART,NAMEART,PRICEART)

SeconTable :

Statistic(IDART,NAMEART,AMOUNT,PRICEART,DATE)

My problem is this :

When i'll put the ID of Article (IDART) in table Statistics then the name and price of that article i want to show them automatically in table statistic...

I hope, i was clear.

Can anyone hel me ????

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by __avd
0

Hello to everyone !!!

I have a problem with a tabels in Acces.

Im making a software for minimarket and i have 2 tabels...

First Table :
Articles(IDART,NAMEART,PRICEART)

SeconTable :

Statistic(IDART,NAMEART,AMOUNT,PRICEART,DATE)

My problem is this :

When i'll put the ID of Article (IDART) in table Statistics then the name and price of that article i want to show them automatically in table statistic...

I hope, i was clear.

Can anyone hel me ????

Your tables shows that you are not good to design a database. However, you should fetch a relative record from table Articles of given IDART and store values (NAMEART,PRICEART) into two variables say mNAMEART, mPRICEART.

Use values of these variables; mNAMEART and mPRICEART to add (insert) a record into the table Statistic.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.