By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 1,945 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Accounts and Products

P: n/a
Hello all

I am fairly new to databasing but learning fast. Using access as my platform
i have created two tables one Accounts the other Products.

What i want to achive is on the prompt account No enter the specific account
number E.g 1 this pulls the account info for that client up onto the screen
and in the second half of the screen is a datasheet embeded to show all the
transaction for that client. What im having trouble with is getting the
products screen to attach the products to the account in question. I can get
it to enter the first product but nothing more one product to one account? I
dont really want to have to create the account each time the client orders
with me.

Dont know if you need more info if you do please just ask i will be happy to
learn how to do this.

Kind regards
Brian

Jun 8 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Your Accounts and Products tables need to look like below and you need more
tables!

TblAccount
AccountID
ClientName
.......
etc

TblProduct
ProductID
ProductName
......
etc

TblOrder
OrderID
OrderDate
AccountID
.....
etc

TblOrderDetail
OrderDetailID
OrderID
ProductID
.....
etc

To get the display you want you need a form/subform, The main form needs to
be based on a query that includes TblAccount and TblOrder. The subform needs
to be based on a query that includes TblProduct and TblOrderDetail.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com


"trogenone" <u34918@uwewrote in message news:7368228761ec3@uwe...
Hello all

I am fairly new to databasing but learning fast. Using access as my
platform
i have created two tables one Accounts the other Products.

What i want to achive is on the prompt account No enter the specific
account
number E.g 1 this pulls the account info for that client up onto the
screen
and in the second half of the screen is a datasheet embeded to show all
the
transaction for that client. What im having trouble with is getting the
products screen to attach the products to the account in question. I can
get
it to enter the first product but nothing more one product to one account?
I
dont really want to have to create the account each time the client orders
with me.

Dont know if you need more info if you do please just ask i will be happy
to
learn how to do this.

Kind regards
Brian

Jun 8 '07 #2

P: n/a
Thank you Steve
I will try this and see how i go. Do i relation them to each ID or ?

Brain

Steve wrote:
>Your Accounts and Products tables need to look like below and you need more
tables!

TblAccount
AccountID
ClientName
......
etc

TblProduct
ProductID
ProductName
.....
etc

TblOrder
OrderID
OrderDate
AccountID
....
etc

TblOrderDetail
OrderDetailID
OrderID
ProductID
....
etc

To get the display you want you need a form/subform, The main form needs to
be based on a query that includes TblAccount and TblOrder. The subform needs
to be based on a query that includes TblProduct and TblOrderDetail.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
>Hello all
[quoted text clipped - 22 lines]
>Kind regards
Brian
--
Message posted via http://www.accessmonster.com

Jun 11 '07 #3

P: n/a
Yes, create relationships between fields ending in "ID" and having the same
name.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com

"trogenone via AccessMonster.com" <u34918@uwewrote in message
news:738d318295c44@uwe...
Thank you Steve
I will try this and see how i go. Do i relation them to each ID or ?

Brain

Steve wrote:
>>Your Accounts and Products tables need to look like below and you need
more
tables!

TblAccount
AccountID
ClientName
......
etc

TblProduct
ProductID
ProductName
.....
etc

TblOrder
OrderID
OrderDate
AccountID
....
etc

TblOrderDetail
OrderDetailID
OrderID
ProductID
....
etc

To get the display you want you need a form/subform, The main form needs
to
be based on a query that includes TblAccount and TblOrder. The subform
needs
to be based on a query that includes TblProduct and TblOrderDetail.

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
re******@pcdatasheet.com
>>Hello all
[quoted text clipped - 22 lines]
>>Kind regards
Brian

--
Message posted via http://www.accessmonster.com

Jun 11 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.