New to this:

[richiejjj]

I want to create a stand alone user-form in which the user will select a customer from a drop down list - which will then indicate products that they purchase and prices for them.

Is this possible in access, and where should i start?

thanks for any advice

Rich

 

[Dobie]

First you must build a table to hold the information you want to display. You may want to have two tables, one with the customer details, then another for the items purchased. then build a form to display the data, use the form wizard to do this. You can then either have sub records to show the items purchased all on one form or each item on a seperate form. I prefer to have another form to search for the customer record. Then a command button to click and open the specified record.

 

[richiejjj]

Thanks very much...

"I prefer to have another form to search for the customer record. Then a command button to click and open the specified record."

Thats the crux of the thing, i shall have to look into doing this..any tips?

Say i have 100 customers who buy from a list of 1000 different products. They will always buy the same 3,4 upto 7 items from us.

So i want to select customer account number or customer name...this will then bring up the items they buy and price and cost.

Can this also be a stand alone or does each user have to have the access db running?

thanks again
rich

 

[scottk]

Ok, I believe this is what you want to do:

1) set up three tables. One for customer information. One for Product information. One for order information. The order information table should contain two fields the Customer ID field and the Product ID field. Use the relationships menu to relate the Customer ID field in the Orders Table with the identical field in the Customer Table also relate the Product ID field in the orders table to the same field in the Products table.

2. Use the form wizard to create a form with a subform. The form should be based off of the customer table and the subform should be based off the orders table. By using the lookup wizard you can make the subform display the product name as found in the product table instead of the product number.

This should work the way I think your wanting it to.

 

[richiejjj]

thanks for the suggestions and help offered.

is it possible when i finish this form, to have that as a stand alone application on someones desktop - or does it all have to be run through access?

thanks

 

[Hayley Baxter]

Pat where can I find this Northwind.mdb? Wouldn't mind taking a look.

Thanks

 

[Rich]

Northwind is in the samples folder or from the MS download site, along with many other example dbs.
HTH