I apologize in advance. I haven't searched, googled, etc. It's late, I'm beat. Curse me if you want 
I have clients, each gets a few trucks. Convenience has named this trucks things like 'truck 1', 'b truck', etc. I have this stuff stored in a 'dat_pseudotrucks' table (ID,client,name).
Basically, I want to have a form where I flip through the date (txtbox with a couple buttons, got that handled), the backend code iterates through the dat_clients table, puts a label with the clients 'name', then kind of like a bulletted list letting me check off the child 'pseudotrucks' under it. A command button will run the code to insert all the records (I could use a hint on iterating through the checkboxes just to get an idea of how it's done). These records go into a 'trips' table that is then linked to stops so all stops have to go on valid trips, but valid trips have to be manager-generated. It's really boring.
I'm thinking I should concentrate more on migrating this to an sql server because I can do it with PHP. Just fighting with the boss and his "Access is pretty" policy ;-). I'll do some searching tomorrow (a few hours from now), but would appreciate a kick in the right direction if anyone has time.
----
JBR
I have clients, each gets a few trucks. Convenience has named this trucks things like 'truck 1', 'b truck', etc. I have this stuff stored in a 'dat_pseudotrucks' table (ID,client,name).
Basically, I want to have a form where I flip through the date (txtbox with a couple buttons, got that handled
), the backend code iterates through the dat_clients table, puts a label with the clients 'name', then kind of like a bulletted list letting me check off the child 'pseudotrucks' under it. A command button will run the code to insert all the records (I could use a hint on iterating through the checkboxes just to get an idea of how it's done). These records go into a 'trips' table that is then linked to stops so all stops have to go on valid trips, but valid trips have to be manager-generated. It's really boring.I'm thinking I should concentrate more on migrating this to an sql server because I can do it with PHP. Just fighting with the boss and his "Access is pretty" policy ;-). I'll do some searching tomorrow (a few hours from now), but would appreciate a kick in the right direction if anyone has time.
----
JBR
