4 Replies - 4689 Views - Last Post: 10 September 2012 - 02:58 PM

#1 maxell7857  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 06-September 12

Access getting Multiple Product into one sales form

Posted 06 September 2012 - 10:26 AM

hiya guys i am trying to make a simple database which manages my stock and sales at the moment but i haven't worked on database for a few years and need a little help. I have so far made a database with working relationship but the problem i am having is that i cant seem to get the query or the form to take it multiple items from product list when making a sale.

please point me at the right direction

thank you
Is This A Good Question/Topic? 0
  • +

Replies To: Access getting Multiple Product into one sales form

#2 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9196
  • View blog
  • Posts: 34,542
  • Joined: 12-June 08

Re: Access getting Multiple Product into one sales form

Posted 06 September 2012 - 11:43 AM

Give us an example of your data and what you want it to look like... oh and relevant table(s) structure.
Was This Post Helpful? 0
  • +
  • -

#3 maxell7857  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 3
  • Joined: 06-September 12

Re: Access getting Multiple Product into one sales form

Posted 07 September 2012 - 03:04 AM

4 tables
tblSuppliers, tblStock, tblCustomers, tblSales

the problem i am having is making a form/ query which can get data of multiple items from stock. basically I want to be able to sell multiple products at the same time. i know i have a problem with the suppliers and product relationship but i can fix that later with a link table. if you could just help me with my sales i would appreciate it ALOT!

thank you

Attached image(s)

  • Attached Image

Was This Post Helpful? 0
  • +
  • -

#4 modi123_1  Icon User is online

  • Suitor #2
  • member icon



Reputation: 9196
  • View blog
  • Posts: 34,542
  • Joined: 12-June 08

Re: Access getting Multiple Product into one sales form

Posted 07 September 2012 - 07:04 AM

I am still unclear of the problem.

If you want to get multiple items from stock then

select <column names> 
from tblStock_lst


Your sales table should be rearranged to be just the sale id restaurant id, special requests, and date entered.. then you need a second table for sales id, product id, and quantity (oh and date entered).
Was This Post Helpful? 0
  • +
  • -

#5 June7  Icon User is offline

  • D.I.C Addict
  • member icon

Reputation: 104
  • View blog
  • Posts: 904
  • Joined: 09-December 08

Re: Access getting Multiple Product into one sales form

Posted 10 September 2012 - 02:58 PM

You need a SalesDetails table that is dependent (child) of Sales table. Then use form/subform arrangement for data entry.

Have you looked at the template Sales db or the Northwind db?

What version of Access are you using?

This post has been edited by June7: 10 September 2012 - 03:00 PM

Was This Post Helpful? 0
  • +
  • -

Page 1 of 1