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.