Program to generate all possible records for a table structure 1

[Paul77fox]

Hello guys. I'm new in ms access and I would like to know how to generate all the possible records for this table structure:
client_ID : month_id : service_id : amount
I have 30 clients, 10 months and 35 services
I would like to have 30x10x35 records in my table (generated programmatically) with amount "null" of course. Is this even possible? Thnak you and have a nice day!

 

[PHV]

I assume you have a client and a month and a service tables.
If so you don't need a program but a single query like this:

INSERT INTO yourTable (client_ID, month_id, service_id)
SELECT C.ID, M.ID, S.ID FROM tblClient C, tblMonth M, tblService S

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Paul77fox]

Just perfect! Thank you PHV