From Forms** combobox select services, services be saved in row for each customer.

[Shoebnisar]

Dear All,
Is it possible from forms combobox select services, the value be stored into tables row wise, may be up to 10 items (horizontally)...? And for every customer the services may differ... for some it may be upto 5, and for some it may be 6, 7, 4 any thing...

Example

Client ID	Client Name	Service 1	Service 2	Service 3	Service 4	Service 5	Service 6
xyz	abc	def	ghi	jkl	etc	etc

[td]

1​

[/td]​

 

[Uncle Gizmo]

That is the Excel way of doing things and it doesn't apply to MS Access...

If you do go that route you will quickly run into problems which are practically impossible to solve!

To model that arrangement you've shown there correctly in MS Access the first thing you do is divide it into two tables...

One table for the client details and another table for the service details....

 

[Gasman]

Excel is wide and shallow sheets.
Access is narrow and deep tables.

Do not go the first route in Access. You need to rethink.

 

[DHookom]

Dear All,
Is it possible from forms combobox select services, the value be stored into tables row wise, may be up to 10 items (horizontally)...? And for every customer the services may differ... for some it may be upto 5, and for some it may be 6, 7, 4 any thing...

Example

Client ID	Client Name	Service 1	Service 2	Service 3	Service 4	Service 5	Service 6
xyz	abc	def	ghi	jkl	etc	etc

[td]
1

[/td]​

I think Shoebnisar is not being understood. I read the input screen would look like a spreadsheet but the data would be stored “row wise”. You can write some VBA to append as many records as have been entered into the combo boxes. It would be a basic loop through the combo boxes that I would name with a numeric suffix.

 

[June7]

As Duane said, it is possible to have a "non-normalized" form for data entry and save the data into "normalized" table by use of VBA. But why? Are you certain that 10 items is the forever upper limit?

 

[plog]

Why do you want it like that? Typically a 1 to many relationship (as in your 1 Customer to many Services) is done with a subform that scrolls vertically like so:

ServiceNumber	ServiceType
1	abc
2	def
3	ghi

If you have more services to add to a customer, just keep adding new records. If you have less you don't have a ton of empty records on the screen. Use just as many rows as you need--no more no less. Super easy to do with forms in Access.

What you described is not impossible but very difficult to achieve. Why do you want it the way you asked for?

 

[Uncle Gizmo]

I think Shoebnisar is not being understood.

The op has started three posts which have all received responses but the op has declined to comment so far...

Hence I am not to prepared to answer the op question in detail until I detect a real live engaging person...

 

[DHookom]

I’ve created un-normalized input forms to match timesheets or other forms that make the most sense and provide ease of use for employees/users. The code to load for edit or save to a normalized table is trivial. I wouldn’t make my users change their sensible paper forms or data entry screens. We’re talking less than an hour of programming for most of us.