could someone help me with a MsAccess database problem

Forums: Web Development
Email this Topic • Print this Page

hello.

Am writing a small prog in VB6.0 (novice) and i wish to use MS Access databases.

My problem:

In the program am writing i have some products which i need to sell at different
locations and each location has diferent seling prices.

the quantity of products as well as the number of locations is not fixed.

so if i have 20 products being sold at 12 diferent places , and at diferent
prices , that would be rather too complicated to fill in a single table

I need help about building the database with several tables and linking them.

If possible provide help(examples) on Vb code to read the database. am using DAO
3.6 obj lib

get me out of this trouble Wink

thanks

Topic Stats
Top Replies
Link to this Topic

Type: Discussion • Score: 1 • Views: 559 • Replies: 2

No top replies

My database subject is this semester. Sorry that you asked the question 6 months too early for me.

0 Replies

Actually, I think you could do it with a single table (I'm in a rush, though, so I don't have much time to explain). Or maybe I'm not understanding the question.

Anyway --

Code:

Product    Price   Reason for Price

Apples   $1   In season

Apples   $2   Not in season

Etc. See what I mean? Just make a field for the reason for the price, unless it's calculated. It's just not very clear as the question is written.

0 Replies

could someone help me with a MsAccess database problem

Related Topics

Quick Links

My Account

able2know