Input rows multiple times depending on selection - Database

Hi,

Thank you!
I don't know much about writing macro's, but I'm trying.

I had another idea for the multiple selection in the drop down list:
In the drop down list you type or select the product you want (same mechanism as google search bar), push the "Select" button, and then it will appear in the Product(s) selection box.
All the products in the product(s) selection box will be added in the database.

I added this example in the file:

Hi,

It doesn't seem to work that well?
The select button doesn't work for the product, the drop down box of the family name freezes...

But I think this is a work in progress, no?

Thank you.

Check this...

Google type search box is disabled for time due to spacing issue, combo box working fine..Almost done except multi product adding in to dbase,

check & let me know how you want to add it..

Clear button added to clear old selected item & adding new items..

On pressing add to database you will get prompt for offer as you wanted...

Cheers!

Hi,

Ok, great! Thank you.

Though I am missing the following:

2) The drop-down list has to be like the google search bar, f.e. if I write "i" in the field family name, Smith & Pitt should only be displayed in the drop-down list.
4) If the whole family buys a Book and a Game, I mark the button "Whole Family", and by doing so, the field of the first name is crossed (so I do not have to input data in that field) and in the database rows are automatically added for all of the family members.
5) If I type in the first name, the family name will be filled in automatically.
6) If family Smith or one of the members of the family wants to buy a 2nd Book with a promotion 1+1 for free on the same delivery date, I get a warning that they already have the 2+1 for free promotion.

I noticed that there is a formula in C10 on the sheet "Input", what's the reason for it?

If someone can help us finding a solution, I would be very grateful.

Thank you.

Hi,

Okay, thank you.

About no. 2 and 5:
Is there a way that I do not have to press alt + down?
It doesn't seem to work that well? I got this:
Naamloos.png

Explanation about no. 4:
F.e. all members of the Smith family bought a game.
The Smith family consists of John, Albert and Sylvia (see sheet Client list). If I mark the box "Whole Family", the box of the first name will preferably get dark or crossed, so no name should be entered, because the game will be for John, Albert and Sylvia.
Thus in the database 3 rows will be added.

About no. 6:
Is it possible to get a warning if the promotion box is not blank and when the same product for the same family member, on a same delivery date is already entered?

Thank you!

hi did you checked this?

Hello,

Yes, it looks nice and seems to work well. Thank you!
I will later look into the code, in detail.

So I might pop up with other questions later. For now, it seems pretty good to me.

Thank you Excelliot.