A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Order Entry subform



 
 
Thread Tools Display Modes
  #1  
Old February 5th, 2010, 04:16 AM posted to microsoft.public.access.forms
Rachel
external usenet poster
 
Posts: 187
Default Order Entry subform

Ok - I am going around in circles with this one! I know it has probably been
answer a number of times and there are a few examples out there but I just
can't seem to get it to work on my database.... this might be a bit long
winded for a very simple answer but here goes.....
I am trying to create an order entry subform to input orders for my
customers. I have:
CustomerTable (ID, FirstName, Surname etc)
ProductCategoryTable (CategoryID, CategoryName)
ProductSizeTable (SizeID, SizeName)
ProductsTable (ProductID, Category, Size, ProductName, UnitPrice)
OrderTable (OrderID, OrderDate, OrderTime, TotalPrice etc)
OrderdetailsTable (OrderID, CategoryID, ProductSize, ProductName, Quantity,
UnitPrice, etc)

Do I need to use a query to create the subform from?
I want to use combo boxes to select category, then size then product and for
it to then populate the price etc.
I am struggling to get the combo boxes to display the correct information
from the correct source.

Do I use the CategoryTable for the cboCatergory control source or the
ProductsTable, or the OrderDetailsTable?

How do I synchronise the combo boxes? I can't get 2 combo boxes to
synchronise let alone 3!

And then how does it all get saved back to the OrdersTable and then linked
to the Customer?

Ahhh!

Any help is much appreciated
Thanks,
Rachel
  #2  
Old February 5th, 2010, 06:53 PM posted to microsoft.public.access.forms
EddWood[_2_]
external usenet poster
 
Posts: 25
Default Order Entry subform

Hi Rachel,

Have you create any Primary Keys between your tables:

i.e. In your orders table have you added a field for CustomersID?

As without these in place you will not be able to complete what you are
looking for




"Rachel" wrote in message
...
Ok - I am going around in circles with this one! I know it has probably
been
answer a number of times and there are a few examples out there but I just
can't seem to get it to work on my database.... this might be a bit long
winded for a very simple answer but here goes.....
I am trying to create an order entry subform to input orders for my
customers. I have:
CustomerTable (ID, FirstName, Surname etc)
ProductCategoryTable (CategoryID, CategoryName)
ProductSizeTable (SizeID, SizeName)
ProductsTable (ProductID, Category, Size, ProductName, UnitPrice)
OrderTable (OrderID, OrderDate, OrderTime, TotalPrice etc)
OrderdetailsTable (OrderID, CategoryID, ProductSize, ProductName,
Quantity,
UnitPrice, etc)

Do I need to use a query to create the subform from?
I want to use combo boxes to select category, then size then product and
for
it to then populate the price etc.
I am struggling to get the combo boxes to display the correct information
from the correct source.

Do I use the CategoryTable for the cboCatergory control source or the
ProductsTable, or the OrderDetailsTable?

How do I synchronise the combo boxes? I can't get 2 combo boxes to
synchronise let alone 3!

And then how does it all get saved back to the OrdersTable and then linked
to the Customer?

Ahhh!

Any help is much appreciated
Thanks,
Rachel


  #3  
Old February 5th, 2010, 07:03 PM posted to microsoft.public.access.forms
EddWood[_2_]
external usenet poster
 
Posts: 25
Default Order Entry subform

OrderTable (OrderID, OrderDate, OrderTime, TotalPrice etc) Add CustomersID
( Do not use the default ID autonumber for your invoice ID create a new
field for that)

OrderdetailsTable (OrderID, CategoryID, Quantity,UnitPrice, etc) Add
ProductID, SizeID

ProductsTable (ProductID, CategoryID, SizeID, ProductName, UnitPrice)

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:53 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.