design of subform

[blueman]

I am going to try and simplify this. I may need changes in the
underlying tables but here is what I'm trying to do:

I am building a form for my business do enter Job information for a
specific customer. I have the main form as the general job information
and it is tied to the customer table with the customer ID.

What I need is a subform to enter job details where I provide
different and multiple "regular services" for 1 job. That is not a
problem and I have made a datasheet subform to enter this information
including service, price, details, etc.

The problem I;m having is trying to figure out how to design in "sub"
services (if they are needed) for each "regular service" that I enter.
I have have various services (sub services) which would be tied to
each service that I list in the "services subform". The rest of the
information associated with the sub service would need the same
additional fields that I have in Services )i.e Quote, Date, Details).
The only difference is that these sub services would be dependent on
doing a regular service. It may not even have to have it's own
table??? but it should look like it is a subset of the service above
it on the form. I"m having a hard time figuring out how to achieve
this design or if there is a better way to tackle this. Any help would
be appreciated.

Thanks

Mike

PS - If it matters, I don't know VBA. I'm not a programmer and just do
this for my business

 

[ruralguy via AccessMonster.com]

You can have two SubForms side-by-side on a form and have one linked to the
selected record on the other SubForm similar to what Albert has done on this
link:
http://www.members.shaw.ca/AlbertKallal/Articles/Grid.htm

And YES you are probably going to want an additional table for the SubSub
services.