A complicated form... (Got screenshots + db link to help)

[eddrimmer]

Hi

I'm hoping someone can help with what im seeing to be a complicated form. Basically I'm putting together a computer shops database, so far it has every function working as I want it to be but the main form, 'New Sale' is being a real hard one. The form asks the user to chose their Staff ID via combobox, the customer ID via combobox (and should display details of the customer, i.e. address, name, postcode) and then a subform which will display sale items once they have been added. The adding of sales items is what im getting stuck on. I dont see how I can get the user to 'pick' which items to add. Any ideas on how it could/should be done?

Below are a few screenshots which should explain things a bit more:

And finally if you think it would help, a link to the database (724kb in size)

http://www.rimmers.eclipse.co.uk/ComputerShopDB.zip

I Appreciate any help I get!

Thanks in advance
Edd

 

[KenReay]

Hi

Nothing strange in what you are trying to do, having the items in a sub form is OK, have you set the master/Child relationship values on the sub form control ?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[eddrimmer]

Hiya

Thanks for your reply, glad to know im heading the right way...

What do you mean by Master/child relationship ? I cant see anything mentioning either under the options!

What im trying to do is have some way to 'add' items to the sale, weither that be by another subform or on some function on the NewSale form, but I'm not sure of a way to do this.

 

[Axoliien]

I don't know if this is the kind of thing you are looking for, but it worked for me last semester in final project.

I made a standard list box, then set the rows to be a query that listed the inventory name, price, and total in stock.

I made another list box and set its rows to be all items in the current order.

I then put a text box underneath the list boxes and a button underneath the list box. In the code, I had verification that a selection had been made from the list boxes, an integer was entered in the text box, and all required information was selected (any information to determine the purchase ID, account ID, customer ID, whatever you need). When they pushed the button, it added the selection in the inventory box to the order, and refreshed the inventory list and the order list.

The effect is that everything is updated as you go along the order, and the user can see everything going on in one page.

I'm sorry, but I don't have a screen shot right now, but I think you could imagine pretty well what it would look like.

 

[DUF]

Hi,
Check out the NorthWind Database that comes with Access
I have build a barcode sacnning inventory program for a Fashion Shop using the examples from Nortwind Db with modifactions.
Look at the afterUpdate Function of the ProductID text box in the Subform of the Orders Form (Dlookup)

Best of luck
If I can be of any more help call

Duf